I have a workbook with multiple sheets in it, and I want to read data from each sheet. I want to append all sheets data to create one big DataTable for easier process.
However, the workbook is poorly organized, and each sheet contain some different columns. Some sheets contain more columns than other sheets.
I don’t need to worry about those inconsistent columns, and I only need to retrieve columns that are common to all sheets. The column orders are also slightly different depending on the sheet, so I cannot use actual range for Read Range.
There are about 7-8 columns that I need to retrieve row data from, and I know the names of these columns.
Is there any way to retrieve data only from specified columns, instead of range? How should I go about this?