formula for coping a cell from a diffent sheet

  • Thread starter Thread starter Shallow
  • Start date Start date
S

Shallow

i would like to copy a cell from a different sheet onto the one sheet i am
viewing
is there a formula for that?
 
You can't copy by formula, but you can link by formula:

=Sheet3!B9

will display the value in B9 on Sheet3
 
SWEET!
THANK YOU

Gary''s Student said:
You can't copy by formula, but you can link by formula:

=Sheet3!B9

will display the value in B9 on Sheet3
Click to expand...
 
You are welcome!

Be sure to remember that a blank in B9 will display as 0 in the display cell.
 
You can actually copy it that way without any typing, especially handy if
you want to do more than one cell

Copy the cell/cells, got to where you want it and do edit>paste special and
select paste link

--


Regards,


Peo Sjoblom
 
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

Complex formula help , please. 13
Automatically name all Sheet Tabs from a list 4
need a macro to append data to a table 3
How to find specific field value in sheet. 2
Using text in a cell in a formula 2
Best way to pull data from several different sheets into a summary sheet 2
Excel A CountIF question... I think 2
Copy reference cell with alternate column 4

Back
Top