brindu
10-20-2009, 11:35 PM
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.
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.