I have 2 workbooks in the spreadsheet. They are linked with a formula so that for example if a number in A1 is changed the number in A1 of the 2nd worksheet also changes.

If I were to insert a row in the 1st worksheet, I would like the 2nd worksheet to also have a row inserted automatically. How do I do this?

Thanks

Emyn