Hello Excel Masters - Seeking your help on the following:
I have a workbook with two tabs, sheet1 and sheet2
Sheet1 cell A1 = 5
Sheet2 cell A1 contains the formula =Sheet1!A1 which = 5
If I select sheet1 row 1 and insert a new row so that 5 is now in cell A2, the formula in Sheet2 cell A1...