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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy cells in Excel 1
Excel VBA 0
Ref in two worksheets 1
Working with worksheets in the same workbook 1
Linking a workbook to worksheets 1
Linking cell in different worksheets in the same workbook 1

Back
Top