linking cells from worksheets in the same workbook

A

Al

HELP! how do you link one cell from one worksheet to
another cell in another worksheet in the same workbook?

example - worksheet 1 (January ending balance) = worksheet
2 (February begining balance)
 
A

Alby

Click the cell that contains the data you want to link
to, and then click Copy on the Standard toolbar.
Click the cell you want to link from, and then click
Paste .
Click Paste Options on the the top toolbar and then
click Link Cells.
 
D

Don Guillett

=sheet2!a2
or if you have a "named" range on another sheet, from anywhere
=mynamedrange
 
Top