How to combine multiple Excel files into Folder to be in one Excel file and data collection?

[abdelfattah]

greeting for everyone

I have 97 separate Excel files inside a folder. These files are data for the classes and their quantities listed for my warehouses. Some of these items are duplicated in some files. the combining data in sheet1,sheet2,sheet3 in one file exel

I would like to collect these files and items and their quantity so that they are in one file, so that the collection file has the item number and the front of the total sum of the received quantities so i want the collection in

i truly appreciate if anybody help by vba

thanks advance

 

[sandy666]

I'd suggest Power Query
PowerQuery add-in for XL 2010/2013, all above has PQ built-in
but I see you decided for vba
good luck

 

[abdelfattah]

hi sandy actually i don't master using power query always i see many people talk power query especially the code i no know where is put it in the normal case put it in module but power query i no know that's why i don't like use it and i think by vba maybe fast if i have data more 100000 rows
thanks for your suggestion

 

[sandy666]

thanks for your suggestion

You are welcome

Power Query is designed for big data (no limits) much more than worksheet can

Have a nice day

 

[abdelfattah]

can you teach me how do that i would

 

[sandy666]

can you teach me how do that i would

no, but you can read this
more about PowerQuery aka Get&Transform

• What is PowerQuery (Get&Transform)
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference (erratum required)

 

[sandy666]

and see this