Macro setting - Data contained in the first row

Question

Hi Team,

I Have used Macro for "Read_All_Excel_Files" which is available in Gallary to consolidate all excel file with different schema. However the headers are taking the first row of the file, but in my scenario, there is data contained in the first row, so how do I change the settings in the Macro file as the first row contains data. If not provide me an alternate solution.

Macro attached.

Regards,

Lalaiah

Read_All_Excel_Files.yxzp

Sebastiaandb · Accepted Answer

Hi @Lalaiah

Within the Excel File Opener macro you will find the Sheetreader macro. In this macro you have to set the input data tool to "First row contains data".

I attached a modified version for you :-).

let me know if it works out for you!

Greetings,

Seb