Insert new row in 2 worksheets

O

Object

I am relatively new to excel so i am hoping my question is a easy one.
have 2 worksheets. Worksheet 2 references the values in worksheet 2
However when i insert a row in worksheet 1, worksheet 2 will now ski
the value of the new row of worksheet 2. How can i get worksheet 2 t
update with the new row/s?

I am using the function

=Sheet1!A1
=Sheet1!A2
=Sheet1!A3
...etc

Thanks for any hel
 
O

Object

Whoops, a typo in my last post, let me try that again...

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 2. 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
 
Top