Expert: Jan Karel Pieterse - 10/21/2009

Question
Hello

In excel 2003  consider 12 workbooks(A-L) with 50 sheets each.The sheets are identical in all the workbooks.When I insert a row in a sheet  in workbook A I want a  row to be inserted in a particular sheet in all the other workbooks starting from B and copy the relative formuala from the previous row of the destination to the inserted row.

This process should be repeated when a row is inserted in any of the other workbooks .
Row inserted in Workbook A ---> the process repeated for all workbooks from B-L
Row inserted in Workbook B ---> the process repeated for all workbooks from C-L
Row inserted in Workbook C ---> the process repeated for all workbooks from D-L

and so On

Please let me know how this can be done

Thanks a million in advance.


Answer
Hi Ramar,

Forgive me, but can I question your data design first?

Why would you want to have 12 workbooks with 50 worksheets each with identical design?
Why not put all data on a single sheet? Excel is much, much better in creating summaries on data structured like that.

I would create one sheet with all data and have (if needed multiple) sheet(s) for representation (printing for example) on which you use some cells to filter the data needed to be shown.