Thomas and Dave from EE were so kind to help me consolidate multiple worksheets. I'm very happy with the results. But when I run the macro I experience some errors as following:
Please see my file attached.
1/ Please note I highlighted in yellow the names in column B. These names are represent the tabs name for each worksheet in the workbook. I don't want these names here.
2/ Please note the data roll up from SWIFT worksheet are missing. It begins with 2 blank SWIFT row, and end with #12 data. Missing #13 and #14.
3/ The data also are missing from PEG worksheet. It begins with 2 blank PEG rows like SWIFT above, and end with #4. Missing #5 and #6 data.
4/ It would be nice if the header can roll over too.
Can you please help.