Macro to perform mass header change on 100 worksheets
 

Hello,

I have 100 worksheets, where I need to change the header.

I would like to be able to change the header on one worksheet and than
have some type of automation to change the other 99 worksheets.

Thanking you in advance.

Diana.

Macro to perform mass header change on 100 worksheets
 

Assume the sheets are in the same workbook and are contiguous in the tab
order with sheet 1 as the first and sheet 100 as the last.
click on sheet 1, hold down the shift key, click on sheet 100

Change the header
Right click on a sheet tab and select ungroup sheets.

Regards,
Tom Ogilvy

"Diana" wrote in message
om...
Hello,

I have 100 worksheets, where I need to change the header.

I would like to be able to change the header on one worksheet and than
have some type of automation to change the other 99 worksheets.

Thanking you in advance.

Diana.

Macro to perform mass header change on 100 worksheets
 

You could also do it with a cell reference. If all of the sheets
heafers referenced the first sheet's headers, then as soon as you made
a change on the first, they would all follow suit.

a formula like =Sheet1!$A$1 should work.


On Wed, 6 Aug 2003 11:10:32 -0400, "Tom Ogilvy"
wrote:

Assume the sheets are in the same workbook and are contiguous in the tab
order with sheet 1 as the first and sheet 100 as the last.
click on sheet 1, hold down the shift key, click on sheet 100

Change the header
Right click on a sheet tab and select ungroup sheets.

Regards,
Tom Ogilvy

"Diana" wrote in message
. com...
Hello,

I have 100 worksheets, where I need to change the header.

I would like to be able to change the header on one worksheet and than
have some type of automation to change the other 99 worksheets.

Thanking you in advance.

Diana.