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