Maintaining Cell Links when rows are deleted or cut/pasted in Excel
Posted on 2003-03-25
I am trying to link cells between 2 worksheets in the following way....
Data is in Sheet1, Cells in Sheet2 also display the same information as cells in Sheet1....
If the user deletes and/or cuts Row27 from Sheet 1, I want the linked cell in Sheet2 to update based on the new information in Cell A27 (ie. what was in cell A28)....right now, I just get the #REF! error because there is not longer the link....same thing goes if I move Row27 down below Row30...I want the order on Sheet 2 to automatically update....
Can you help?