John Supsic
New Member
- Joined
- Oct 22, 2008
- Messages
- 4
Hi-<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am brand new to Mr. Excel and would love some advice. <o></o>
<o></o>
I searched the boards pretty extensively but could not find what I am looking for...I apologize if this is a duplicate.<o></o>
<o></o>
I am using Excel 2007<o></o>
<o></o>
How do you automatically add rows and update values for cells to a linked worksheet in which rows have been added? For example: Sheet 1, columns A & B are linked to Sheet 2, columns A & B. Sheet 2 has values in A1:A5 & B1:B5 and Sheet 1, since it is linked, has the same info. I want to add a row in between 3 & 4 on Sheet 2 and want Sheet 1 to automatically add the same row and update the value of the cell in column A & B.<o></o>
<o></o>
Any help is greatly appreciated!<o></o>
<o></o>
John<o></o>
<o></o>
<o></o>
I am brand new to Mr. Excel and would love some advice. <o></o>
<o></o>
I searched the boards pretty extensively but could not find what I am looking for...I apologize if this is a duplicate.<o></o>
<o></o>
I am using Excel 2007<o></o>
<o></o>
How do you automatically add rows and update values for cells to a linked worksheet in which rows have been added? For example: Sheet 1, columns A & B are linked to Sheet 2, columns A & B. Sheet 2 has values in A1:A5 & B1:B5 and Sheet 1, since it is linked, has the same info. I want to add a row in between 3 & 4 on Sheet 2 and want Sheet 1 to automatically add the same row and update the value of the cell in column A & B.<o></o>
<o></o>
Any help is greatly appreciated!<o></o>
<o></o>
John<o></o>
<o></o>