Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add or Delete Rows in Protected worksheets | Excel Discussion (Misc queries) | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
Excel needs to have the ability to insert "SUB" worksheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions |