Linking cell in different worksheets in the same workbook

G

Guest

HELP! I'm trying to link a single cell from one worksheet
to another in the same workbook. EXAMPLE: worksheet 1 Jan
ending balance = worksheet 2 Feb begning balance. How do I
get it to cary over the info from worksheet 1 to worksheet
2 without having to do it manually.
 
M

Mark Graesser

Go to worksheet 2. In the cell where you want the number type = (do not hit enter). Then go to worksheet 1 and click on the cell with the value. Hit enter.

You should end up with a formula similar to:

=worksheet1!A1

Good Luck,
Mark Graesser
[email protected]

----- [email protected] wrote: -----

HELP! I'm trying to link a single cell from one worksheet
to another in the same workbook. EXAMPLE: worksheet 1 Jan
ending balance = worksheet 2 Feb begning balance. How do I
get it to cary over the info from worksheet 1 to worksheet
2 without having to do it manually.
 
Top