Updating, Deleting and inserting rows over two Excel Sheets
 

Hi

I am trying to create a a excel model that will let me Update, Insert and
Update on one excel spreadsheet, some of the information will be then
reflected in another excel sheet (same book) I can do the update by using
'=Sheet1!A1'. but if I delete this gives a #ref error and insert rows is not
reflected.

Thanks for help or suggestions.