I have linked several sheets to a primary sheet in a spreadsheet. When I sort the primary sheet, the linked sheet cell references will adjust correctly, but the cell references within the primary sheet will not --- which causes major problems.
Before sorting data in the primary sheet, formula is:
=IF(K2=52,MRP52!E2,MRP12!E2)
After sorting data in the primary sheet, formula changes to:
=IF(K7=52,MRP52!E2,MRP12!E2)
The issue is the reference to cell K2 in the primary sheet ... it changes to cell K7. How do I keep the cell reference as K2 ??
OR should I have the !E2 changed to !E7 ????
Thanks Art Mueller
Before sorting data in the primary sheet, formula is:
=IF(K2=52,MRP52!E2,MRP12!E2)
After sorting data in the primary sheet, formula changes to:
=IF(K7=52,MRP52!E2,MRP12!E2)
The issue is the reference to cell K2 in the primary sheet ... it changes to cell K7. How do I keep the cell reference as K2 ??
OR should I have the !E2 changed to !E7 ????
Thanks Art Mueller