synchronize worksheets in excel 2000. 1

[sigmab]

Not sure if this is possible but is there a way to synchronize worksheets in excel so that if I for example insert a column in one worksheet it automatically gets inserted in a related worksheet. Sorta like mirrored worksheets. Any thoughts????

 

[JVFriederick]

This was quite easy in 123 by using the Group mode...... I often wish Excel would add the same functionality.

Somewhat of a workaround in Excel is to select all sheets prior to the insert by right clicking on the sheet tab, and choosing Select All. Insert the column and so on.

So long as all sheets are selected together (which is not easy to keep that way) your entries will be made throughout all sheets.

Click on a single sheet to de-select all sheets.

 

[sigmab]

Thanks for the info, it worked like a charm.

 

[JVFriederick]

Great.