Macro to perform mass header change on 100 worksheets

[Diana]

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.

 

[Tom Ogilvy]

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

 

[Random]

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.