Pulling cell information from one sheet to another in same databas

C

Caramilk

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!!!
 
G

guilbj2

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.
 
D

David Biddulph

guilbj2 said:
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.
Click to expand...

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