I need some help with some macro development. Below are some details regarding the situation and what the macro must do. File folder contains "non-header row" workbooks without headers and one "master header" workbook that just has a header row of data Macro must do the following Copy the header row that appears in the "master header file" Open a "non-header row" workbook, insert a new row at row 1, paste the header while maintaining the formatting from the "master header" workbook Close the newly edited workbook Open the next workbook Repeat until all workbooks edited I look forward to receiving your help and will be active if you have any questions!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Macro Help - Open Files in Folder & Paste Header Row

I need some help with some macro development. Below are some details regarding the situation and what the macro must do.

File folder contains "non-header row" workbooks without headers and one "master header" workbook that just has a header row of data
Macro must do the following
- Copy the header row that appears in the "master header file"
- Open a "non-header row" workbook, insert a new row at row 1, paste the header while maintaining the formatting from the "master header" workbook
- Close the newly edited workbook
- Open the next workbook
- Repeat until all workbooks edited

I look forward to receiving your help and will be active if you have any questions!