shortcut for transfering info from one worksheet to another?
 

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

shortcut for transfering info from one worksheet to another?
 

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: EditPaste specialPaste link

Biff

"Sleepy Sheep" <Sleepy wrote in message
...
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