Excel Files Consolidator Tool

%3CLINGO-SUB%20id%3D%22lingo-sub-1379890%22%20slang%3D%22en-US%22%3EExcel%20Files%20Consolidator%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379890%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Excel%20Champs%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20every%20faced%20the%20problem%20to%20consolidate%20multiple%20excel%20files%20from%20same%20folder%20when%20numbers%20are%20high%20and%20format%20is%20same%3F%20Inst%20it%20tedious%20job.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20you%20can%20download%20the%20Consolidator%20tool%20and%20VBA%20code%20for%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelsirji.com%2Fvba-tool-to-consolidate-excel-files-from-a-folder%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelsirji.com%2Fvba-tool-to-consolidate-excel-files-from-a-folder%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20give%20a%20like%20to%20this%20post%2C%20if%20you%20think.%20this%20is%20worth%20making%20tool.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20great%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EKapil%3C%2FP%3E%3CP%3EExcelsirji.Com%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1379890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1380013%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Files%20Consolidator%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380013%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F476378%22%20target%3D%22_blank%22%3E%40jukapil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20nowadays%20Power%20Query%20exists%20for%20such%20tasks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1380044%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Files%20Consolidator%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380044%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Byeah%20I%20am%20aware%20of%20Power%20Query%20however%20this%20can%20help%20people%20who%20are%20not%20familiar%20with%20power%20query%20and%20sometimes%20face%20challenges.%20It%20is%20just%20one%20click%20solution.%20So%20thought%20to%20share.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20big%20fan%20of%20yours%20and%20glad%20to%20see%20you%20read%20my%20post.%20I%20am%20following%20since%20I%20joined%20and%20really%20an%20inspiration.%20I%20saw%20many%20of%20your%20answers%20which%20helped%20me%20to%20look%20on%20problems%20from%20new%20angle.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20started%20a%20website%20%22Excelsirji.Com%22%20two%20years%20ago%20and%20keep%20updating%20it%20whenever%20I%20get%20chance%20from%20my%20job.%20I%20will%20be%20grateful%20if%20you%20have%20a%20look%20whenever%20you%20have%20free%20time%20and%20share%20your%20feedback.%20Will%20really%20help.%20I%20am%20currently%20covering%20basics%20these%20days%20and%20developing%20it.%20Will%20not%20waste%20your%20more%20time.%20Have%20a%20great%20day%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EKapil%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382348%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Files%20Consolidator%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382348%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F476378%22%20target%3D%22_blank%22%3E%40jukapil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Kapil%20and%20thank%20you.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20checked%20the%20site%20very%20briefly%2C%20looks%20nice.%20Perhaps%20later%20will%20dig%20in%20more%20details.%20But%20in%20any%20case%20such%20discussion%20is%20not%20for%20TechComm%2C%20it'll%20be%20against%20the%20policy%20to%20advert%20any%20resource%20in%20any%20form.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi Excel Champs,

 

Have you every faced the problem to consolidate multiple excel files from same folder when numbers are high and format is same? Inst it tedious job.

 

Here you can download the Consolidator tool and VBA code for it.

 

https://excelsirji.com/vba-tool-to-consolidate-excel-files-from-a-folder/

 

Please give a like to this post, if you think. this is worth making tool.

 

Have a great day.

 

Regards

Kapil

Excelsirji.Com

3 Replies
Highlighted

@jukapil 

IMHO, nowadays Power Query exists for such tasks.

Highlighted

@Sergei Baklan yeah I am aware of Power Query however this can help people who are not familiar with power query and sometimes face challenges. It is just one click solution. So thought to share.

 

I am big fan of yours and glad to see you read my post. I am following since I joined and really an inspiration. I saw many of your answers which helped me to look on problems from new angle.

 

I also started a website "Excelsirji.Com" two years ago and keep updating it whenever I get chance from my job. I will be grateful if you have a look whenever you have free time and share your feedback. Will really help. I am currently covering basics these days and developing it. Will not waste your more time. Have a great day

 

Regards

Kapil

Highlighted

@jukapil 

Hi Kapil and thank you. 

 

I checked the site very briefly, looks nice. Perhaps later will dig in more details. But in any case such discussion is not for TechComm, it'll be against the policy to advert any resource in any form.