linking cells from worksheets in the same workbook

  • Thread starter Thread starter Al
  • Start date Start date
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)
 
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.
 
=sheet2!a2
or if you have a "named" range on another sheet, from anywhere
=mynamedrange
 
Back
Top