Locking Cell Reference
Posted by Santosh on May 04, 2001 8:41 AM
I am trying to link two worksheets within the same file. When editing the original worksheet, I am getting errors on the linked worksheet.
For example, Worksheet 1 (WS1) contains the data and Worksheet 2 (WS2) is linked to WS1. Cell A1 in WS2 contains the same data as cell A1 is WS1 because of referencing. When I make changes in WS1, it is necessary for me to cut and paste rows, along with deleting and inserting rows. When I delete a row is WS1, it gives me an error is WS2 because the reference cell(s) is gone.
My goal is to have WS2 always referencing the same cell location in WS1. I want cell A1 in WS2 to always look at cell A1 in WS1. If I delete the first row in WS1, then I want WS2 to look at the new cell A1 in WS1 (which was originally cell A2), not give me an error message. The reference in WS2 should still be to WS1 A1, not WS2 A2.
Any help you could give me would be greatly appreciated.