shortcut for transfering info from one worksheet to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
transfer data cell from another work sheet 2
lookup and worksheet name and then do formula 2
Logging info from one worksheet to another 1
shortcut key for selecting the inactive cells surrounding a range 1
Copying info from worksheet to worksheet if info matches 2
Pulling info 2 cells and putting it in one 3
How do I get ONLY new info from 1 Worksheet to another automatical 6

Back
Top