Forgot command to copy data from one spreadsheet cell to another cell automatically

as enter data into a cell on spreadsheet one, I would like to link that cell to another cell on a seperate spreadsheet so it automaticallty fills it in.
At one point or another, I knew the command.

Any help would be wonderful.

Thank you,

You can put this formula in cell A1 of Sheet2:

=IF(Sheet1!A1="","",Sheet1!A1)

and then copy it across and down as appropriate. Then, as you enter data into Sheet1 it will automatically show in Sheet2.

Hope this helps.

Pete

Pete,
I use to use a command key to configure the cells. I do not exactly know how to use this formula. I am so sorry for my ignorance.

You just type that formula into cell A1 of Sheet2, and then use Copy and Paste to copy it to other cells.

Basically, the formula says if the corresponding cell in Sheet1 is empty then return a blank, otherwise return whatever is in that cell.

Hope this helps.

Pete