Hi experts,
Have many excel files (each having 1 tab but different structures) based on a country like this
Is there a possibility to merge by country in 1 single file for each country? for eg; for UK we would have 1 excel file with 2 tabs (FTE & Plan vs Actuals summary) and so on?
Thanks
Hi @ROHANPACH - Here is what you can do. Hope that helps.
Firstly, you read the files:
Then you write them back: