I have one folder and it has 300 excel files and each file has "Data Collection" tab and i am looking for to combine in one excel file. Each file has two section. 1. Application (Unique app) 2. App Server mapping .
I would like to combine App Server Mapping one on one table. I am attaching sample files and one output file too. And it's also good we can merge Application info columns to App-Server mapping.
Is it possible someone to create VBA code for me ?
Thanks in Advance and please let me know if you need more details.