Hello. I have a small problem with excel.
I have two worksheets in one workbook. I want the second one to always reference cell B2 in the first, regardless of the changes I make to the first worksheet.
The problem I have is this: I absolute reference cell B2, but if I insert a new row between row 1 and 2, the reference changes to cell B3! I don't want the reference to change, I want it to look at cell B2. Always. Regardless of any changes I make to the worksheet.
To elaborate further: The first worksheet that is being referenced is always changing. The second worksheet is always fixed. Whenever I make changes to the first worksheet, the reference changes to compensate any change. I don't want it to do this. I want it to always point at B2!
Why does excel have to be so damn smart! I don't want it to try and compensate for changes! I want it to point at B2! Is there a 'dumb reference' function???
Bookmarks