I have a weekly task where I have to compare 3 Excels sheets from the current and previous week for about 30+ columns. I'm looking for a VBA solution to import the Excel file to an existing table (so my queries can run) while using the 1st row as the headers.
The major problem I'm having is the Excel columns may not be the same place each week, and worst case, the spelling of the column may not be consistent week over week (I think I can figure out the error handling part).
Any advice? Thanks.