Linking cell in different worksheets in the same workbook

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

 

[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
(e-mail address removed)

----- (e-mail address removed) 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.