Amending 1 work sheet saving in all

[GeeWhizz]

Hi,

I have created an Excel 2000 workbook. Inside this i have 52 worksheets for
each week in a year. I need to change something in all of the work sheets and
add a new colum. Is there a way to do this in just 1 worksheet and then save
it into all the others without changing each individual sheet?

Thanks In Advance,

Grant

 

[Gord Dibben]

Select one sheet then right-click on the sheet tab and "Select all sheets"

This groups the sheets.

What you do to the active sheet will be done to all.

DO NOT forget to ungroup the sheets when you are done.


Gord Dibben MS Excel MVP

 

[GeeWhizz]

Thankyou Very much, it worked a treat

Grant

Select one sheet then right-click on the sheet tab and "Select all sheets"

This groups the sheets.

What you do to the active sheet will be done to all.

DO NOT forget to ungroup the sheets when you are done.


Gord Dibben MS Excel MVP