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.

Moving cell data in linked workbooks
How to insert picture in word without moving text - Guide
Tmobile data check - Guide
Transfer data from one excel worksheet to another automatically - Guide
How to be offline in whatsapp when data is on - Guide
Mint mobile data not working ✓ - Network Forum

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

Similar discussions

help me to add particular cells

AMD data change update new data to DMI

If a cell contains any text then add a value

Counting cells containing only numbers

Unlock safe folder without losing any data

Similar discussions

Subscribe To Our Newsletter!