Pulling cell information from one sheet to another in same databas
 

Very basic question but I can't figure it out.

How do I pull information (derived from a formula) from cell A1 in one sheet
to cell A1 in a different sheet (but same database)?

THANKS!!!

Pulling cell information from one sheet to another in same databas
 

So one spreadsheet, and you want something from a different worksheet in
the same workbook?

Just type it this way:

Sheet3!A1

With Sheet3 being the name of the sheet you are looking to pull from
(the ! must be added) and A1 being the cell reference on that sheet.


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=541303

Pulling cell information from one sheet to another in same databas
 

"guilbj2" wrote in
message ...

So one spreadsheet, and you want something from a different worksheet in
the same workbook?

Just type it this way:

Sheet3!A1

With Sheet3 being the name of the sheet you are looking to pull from
(the ! must be added) and A1 being the cell reference on that sheet.

Or to avoid having to type it all, type = in the destination cell then click
in the source cell.
--
David Biddulph