G
Guest
Hi all
I have a spreadsheet with a number of sheets. on sheet one is a merge row in
column a with the heading and then various rows with the data
A N 123
B A 123
C M 334
D E 233
The first 3/4 rows are identical on the next sheets and are linked to sheet
1 (if sheet 1 changes the data changes).
However I may need to add a new row in sheet one (in example above a new row
between the 123 and 123. Is there a way that will update the new row on the
other sheets.
Any suggestions greatly appreciated
Rexmann
Ps I use Excel XP
I have a spreadsheet with a number of sheets. on sheet one is a merge row in
column a with the heading and then various rows with the data
A N 123
B A 123
C M 334
D E 233
The first 3/4 rows are identical on the next sheets and are linked to sheet
1 (if sheet 1 changes the data changes).
However I may need to add a new row in sheet one (in example above a new row
between the 123 and 123. Is there a way that will update the new row on the
other sheets.
Any suggestions greatly appreciated
Rexmann
Ps I use Excel XP