Macro to perform mass header change on 100 worksheets

  • Thread starter Thread starter Diana
  • Start date Start date
D

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.
 
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
 
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.
 
Back
Top