updating headers with standard names on different worksheets

[srini0712]

Could any one help with to create a macro for below functionality, please-

within a excel sheet, i have for example 5 worksheets & each sheet containing data with in tables. how can we write code in VBA to standardize the headers in all worksheets such that they all have same headers.

the code should list me the original sheets along with the header names to which i want to update upon selection.

Example:
On sheet 1, i have table 1 as attached.
on sheet 2, i have table 2
on sheet 3, i have table 3

All the 3 tables have different header names.
when i click on a macro, first it should list me the sheets names along with corresponding headers names. Then user should be able to write or select the new header names for each column in the table.

 

[rondeondo]

hi.
Something that may help. If you select all of the sheets, when you edit cell a1 it will update a1 in all of the selected sheets. Also you can apply formatting and column widths across the selected sheets.
Select individual additional sheets with ctrl & click on sheet tab. To select many, select first then shift& select last sheet.