shortcut for transfering info from one worksheet to another?

S

Sleepy Sheep

It's been years, but I remember that there was a shortcut for moving cell
info from one worksheet to another-so that when I changed info on the primary
worksheet, it changed the corresponding info on other worksheets. I don't
remember the long way to do this, much less the shortcut.

If you have any input, I surely would appreciate it.

Thanks, Dave
 
B

Biff

Hi!

You want Sheet1 cell A1 to also appear on Sheet2 in cell G20:

On Sheet2 in cell G20 enter this formula:

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

You could just use:

=Sheet1!A1

But if the cell is empty the formula will return 0. Using the IF formula
accounts for that and will leave the cell blank.

Another method that will do the same thing (except for testing for empty
cells):

Copy the source cell and navigate to the target cell.
Then do: Edit>Paste special>Paste link

Biff
 
Top