I am relatively new to excel so i am hoping my question is a easy one. I have 2 worksheets. Worksheet 2 references the values in worksheet 1. However when i insert a row in worksheet 1, worksheet 2 will now skip the value of the new row of worksheet 1. How can i get worksheet 2 to update with the new row/s?
I am using the function
=Sheet1!A1
=Sheet1!A2
=Sheet1!A3
...etc
Thanks for any help
Bookmarks