Forum Discussion

jukapil's avatar
jukapil
MCT
May 11, 2020

Excel Files Consolidator Tool

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...
BI & Data Analysis
developer
excel
Macros and VBA
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 11, 2020

jukapil 

IMHO, nowadays Power Query exists for such tasks.

jukapil's avatar
jukapil
MCT
May 11, 2020

SergeiBaklan 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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 12, 2020

    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.