Insert new row in 2 worksheets
 

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


--
Object
------------------------------------------------------------------------
Object's Profile: http://www.excelforum.com/member.php...o&userid=33752
View this thread: http://www.excelforum.com/showthread...hreadid=535284

Insert new row in 2 worksheets
 

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


--
Object
------------------------------------------------------------------------
Object's Profile: http://www.excelforum.com/member.php...o&userid=33752
View this thread: http://www.excelforum.com/showthread...hreadid=535284

Insert new row in 2 worksheets
 

Hmmm... :( am i not explaining it properly, would appreciate any help.


--
Object
------------------------------------------------------------------------
Object's Profile: http://www.excelforum.com/member.php...o&userid=33752
View this thread: http://www.excelforum.com/showthread...hreadid=535284