Hi:
I have hundreds of Excel 2007 workbooks in a file location. They are identical in set up because they were created using a password-protected template. They all contain identical column headers at row 19 with an auto-filter. The password is not needed to open the file, update the data under row 19, etc. - it was just there to keep the template standard for all users and protect macros, etc.
What I want to do is combine all workbooks into 1 master workbook (all on 1 sheet) - all under row 19.
What is the quickest way to do this?
Thank you,
Roady
I have hundreds of Excel 2007 workbooks in a file location. They are identical in set up because they were created using a password-protected template. They all contain identical column headers at row 19 with an auto-filter. The password is not needed to open the file, update the data under row 19, etc. - it was just there to keep the template standard for all users and protect macros, etc.
What I want to do is combine all workbooks into 1 master workbook (all on 1 sheet) - all under row 19.
What is the quickest way to do this?
Thank you,
Roady
