Macro for Add Column Header to All Worksheets

Given:
sheet1. NAme = "Header" (where my column header is located)
Sheet2 to Sheet N = where the daily extracted data are located. Each wrksheet has equal number of columns but it has no header.

Problem: A macro that Insert the column header (Row 1) to all the worksheets in the workbook upon clicking a button.

Im newbie in macros programming. You're help will be highly appreciated.

Thanks in advance and have a great day.

hi,

In many cases, the best way to learn how to code to automate repetitive actions is to "record a macro" & then review/use the resulting code as a base - this is one of those times...

To record a macro go to Tools-Macros-Record new macro ie [alt + t + m + r], go through the steps, press Stop on the small popup toolbar (appears for me in Excel 2003). Press [alt + F11] to bring up the VBE, [ctrl + r] to show the "projects" you have open & find the file that contains the new macro. Review the code, test for flexibility & then post back if you have specific questions.

hth
Rob