Hi all,
I am new to VBA and forums in general.
I am trying to compile multiple worksheets from a workbook in a new workbook. 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 where are they located)
2) In case the column headers in all worksheets are identical, compile the contents of the worksheets in a new workbook (depending on the column headers).
Can this be done in VBA or other ways? especially the first part?
I am new to VBA and forums in general.
I am trying to compile multiple worksheets from a workbook in a new workbook. 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 where are they located)
2) In case the column headers in all worksheets are identical, compile the contents of the worksheets in a new workbook (depending on the column headers).
Can this be done in VBA or other ways? especially the first part?