Hey,
Probably a simple one and I'm completely missing the trick.
I want to mirror cell A1 of sheet 2 in A1 of sheet 1
e.g.
On sheet 1 in cell A1 =Sheet2!A1
if on sheet 2 I insert a new row, the formula on sheet 1 will change to =Sheet2!A2.
How do I constantly mirror cell A1 regardless of inserting new rows or columns?
Thanks for any help
Bookmarks