Simultaneouly insert of rows or col. - Ajit

[Guest]

I want excel to automatically insert row below or column
beside in Sheet2 when I insert row or column in Sheet1.
e.g. If I insert row below a1 in Sheet1 excel should automatically
insert a row below a1 in Sheet2.How can I do this?
Ajit

 

[Guest]

Hi Ajit

If you want to insert only rows and columns, then a simpler solution, is
before inserting the rows and columns, select the sheets where you want
automatic inserting of rows and columns and then continue with inserting.
Once the inserting of rows and columns is complete then deselect the sheet
you don't want to work on.

Regards
Raj