Hello,
Ive searched the forum but was not able to find what I needed. Please can you help with the following.
I have two sheets. Sheet1 and Sheet2. In sheet to A1 i put =sheet1!A1 so the value for sheet1 a1 is put in sheet 2.
I then did the same for the columns going down in sheet2 i.e -sheet1!A2 etc
So far so good. But if I insert a row at a2 in sheet1 the changes are not reflected in sheet2.
How can I go about this? Please help.
Thanks
Bin
Bookmarks