Hi all,
I am new to VBA and forums in general.
I am trying to compile multiple worksheets from different workbooks. The worksheet name is identical in all workbooks. Each worksheet is supposed to have the same column headers. I am looking for a way to do following:
1) Test if the column headers in all worksheets are identical (and notify me if there are errors and in which sheet)
2) In case the column headers in all worksheets are identical, compile the contents of the worksheets in a new workbook (using on the column headers).
Can this be done in VBA or other ways? especially the first part?
Bookmarks