Moving cell data in linked workbooks

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have cells linked between two worksheets. However I often move cells around in Worksheet A. I need the data to move accordingly in Worksheet B. That is, I want the cells in Worksheet B to link to the content of the cell and not to the cell number in Worksheet A. Any suggestions?

Many thanks.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I have not use it but I would think that using defined names might do the trick. So instead of cells, you refer to the named ranges