I had to download 60 different excel sheets from my data hub. And want to combine them into ONE worksheet. I tried a few VBA and falling short. There must be a way right?
Basically I just want to say "Hey take these 60 files in folder "C" and merge into one sheet in this excel file i have open"
All the file formats are the same - so same fields just don't want to copy paste them in.
HELP!
Thanks