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

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.27nwjn_1147382701.2516@excelforum-nospam.com> wrote in
message news:guilbj2.27nwjn_1147382701.2516@excelforum-nospam.com...
>
> 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