Previous Topic Next Topic

Moving cell data in linked workbooks

Closed
Bailey - Feb 10, 2010 at 04:28 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 10, 2010 at 05:18 PM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 10, 2010 at 05:18 PM
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
0

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response