How to change a cell's value from another cell?

Hi SGIII

I am using automator,

Can you tell me why I am getting an error with this script

==============

on run {input, parameters}

tell application "Numbers"

activate

tell the first table of the active sheet of document 1

set the value of cell "C4" to item 2 <I want to set cell to 2nd item of pop up menu in numbers

end tell

end tell

return input

end run

===============

Also my numbers document is called xxx and it's on the desktop. this script opens my xxx document. How does it know to open xxx when we say "Document 1" in the script ?

Thanks

Thanks for getting back.

well, typically I have a template file in numbers which I use to make my orders.

so for every order, I make a copy of the template file and use it as my order file.

Therefore basically i typically make a copy of this file for every order I do.

so it’s like:

<template file>

<copyFor order 1>

<copy for order 2>

and so on.

So for example suppose I make a third copy of my template for order#3, and save it like this:

<copy for order 3>

But now as I fill out <copy of order 3> all to often I modify some settings in the file like bold some text or add a column, add some borders Ect….

when I save <copy of order 3>, to avoid redoing all these on the fly changes I just did, I also save the <copy of order 3> file as:

<template file>

so the <template file> is up to date also with all the latest changes.

But now the template file contains all the data entered from

<copy of order 3> file.

So when I need to make

<copy of order 4> file. I find myself resetting all the data in the <template file> every time.

it would be nice that after every time I get into this scenario and save my order file as the template file, that I would type an “X” in a random cell somewhere, and automatically all the data is reset so that my template file is ready to use and can start from a clean slate.

any suggestions on how to reset my infos in a numbers file automatically?

thanks

“One version is a shortcut you can download and install and try out.”

what’s a shortcut that I can install ??? What is this? An app?

“The other is a script that operates a little differently. The script can be run using the Script Editor application. Copy/paste it into a new document in that app. In Numbers, select the range of cells to be cleared. In Script Editor, hit the play button.”

where and how do I access the script Editor- application?

can a the script editor application also select specific items from a drop list in cells?

a little confused because I never striped scripts ?

Also is it possible to achieve this without learning how to script?

i just want to be able to record the steps I do in my numbers sheet and the execute those steps when ai need them … and that’s it !

let me know if there is a way to do this thanks so much !

Wait I make a video

So apparently we can’t record operations within a numbers sheet because Numbers scripts aren’t recordable ? Is this correct !

Ok thanks let me give it a try

👍👍