Hi all
I have about 15 excel files, all containing 3 tabs. All 15 files have same layout, but the layouts of the 3 tabs is different.
I created a set of queries; the first 3 parse through each of the 3 tabs, and the 4th appends the 3 result sets together.
What I'm now looking to do, is find a way to repeat the above 4 steps on all 15 files that I have, and consolidate the result into one file.
Would anyone know if this is possible at all?
As always, many thanks in advance for your help
Bart
I have about 15 excel files, all containing 3 tabs. All 15 files have same layout, but the layouts of the 3 tabs is different.
I created a set of queries; the first 3 parse through each of the 3 tabs, and the 4th appends the 3 result sets together.
What I'm now looking to do, is find a way to repeat the above 4 steps on all 15 files that I have, and consolidate the result into one file.
Would anyone know if this is possible at all?
As always, many thanks in advance for your help
Bart