Merging multiple files to 1 file based on a criteria

Question

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

ArtApa · Answer

Hi @ROHANPACH - Here is what you can do. Hope that helps.

Firstly, you read the files:

Then you write them back:

ReadWrite.yxzp

Countries to FileAA.zip

Laurap1228 · Answer

If all the FTE files have the same structure and all the Plan vs. Actuals summary have the same structure, you can try the attached solution.

It uses a batch Macro to Import the files and write them out to a single file one country at a time.

file input example.yxzp

Country Files.zip