how do I format a cell reference to move as source changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel - how do I format a reference cell so that the reference changes as
the source cell changes. example: Source cell on one worksheet; reference
cell on a linked worksheet. If I resort the worksheet and the source cell
moves, the reference is not moving with it. The reference cell remains
linked to the first cell on the source sheet. I have used both formats of
anchoring with a $ and using nothing. Help.
 

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

How do I create a formula that references a specific tab in Excel? 1
How do I use the text content of a cell as a worksheet reference? 9
Move cell and maintain reference 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Reference the same cell based on tab name 1
Absolute References and worksheets 0
Formula refers to empty cells even when cells contains data 1
The absolute referenced cell does not move when source cell moves 2

Back
Top