Merge/Combine Multiple Excel Files into one Excel File (Hindi)

In this video, i have explained that how to merge or combine multiple excel files data into one single file or sheet in Microsoft Excel.
Download Practice Sheet Here:
👉 www.techguruplu...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉 Buy Excel Course: - TechGuruPlus.c...
👉 My Instagram: - / techguruplus
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
(1) Excel की सारी वीडियो यहां पर देखें
🔹 • Top 20: Advanced Excel...
(2) Tally की सारी वीडियो यहां पर देखें
🔹 • Email through Tally wi...
(3) Pivot Table की सारी वीडियो यहां पर देखें
🔹 • Pivot Table Part-1 in ...
(4) Macro की सारी वीडियो यहां पर देखें
🔹 • MACRO (PART-2) Salary ...
(5) Tally TDL की सारी वीडियो यहां पर देखें
🔹 • Download All TDL File ...
(6) Online Tricks की सारी वीडियो यहां पर देखें
🔹 • Restore Chrome Tabs Af...
(7) Sponsored की सारी वीडियो यहां पर देखें
🔹 • Edraw Max: Perfect Sof...
(8) Gadgets Review की सारी वीडियो यहां पर देखें
🔹 • MI Power Bank 10000mAH...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
My Social Media Links:
(1) Excel Expert's Facebook Group
🔴 / excelexpertgroup
(2) LinkedIn
🔴 / nazimkhaan
(3) Facebook Page
🔴 / techguruplus
(4) Twitter
🔴 / techguruplus
(5) KZbin
🔴 / techguruplusindia
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Contact for Business Inquiry :
✉ [e-mail]
✉ [e-mail]
Channel Owner: Nazim Khan
🏆 Experience: 10 Years+
⏳ Website : ► www.TechGuruPlu...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
#TechGuruPlus #NazimKhan

[@business-excel]

Download Practice 👉 www.techguruplus.com/merge-combine-multiple-excel-files/ Join my Excel Course 👉 TechGuruPlus.com/Excel-Course/ Contact 👉 9536250020 My Instagram 👉 instagram.com/TechGuruPlus

[@pa2happiness13]

💞👌🏼

[@ramanjeet1111]

IZ THERE AN ONLINE WEBSITE WHERE I CAN RUN VBA CODES......AND IT WILL CORRECT ME ACCORDINGLY

[@dharmendravishwakarma4947]

It's possible to update automatically

[@gursewaksingh7570]

How to consolidate all four quarter return data ( from four different sheets) for annual return

[@swatitoliya5036]

I have done from this technique and merged 20,000 data In excel..thank you so much for this..

[@business-excel]

Great 👍

[@PravinKumar-we3bq]

sir i have watched many videos but you are the best one

[@kamalkoli8937]

Superb It's help a lot in my work

[@armaanansari2805]

Sir I swear ur the best ..Allah bless u always

[@ndtiwariii]

verry easy to understand, thanku sir

[@pappujoshi5219]

बहुत अच्छा विडियो है सर ।

[@rajibroy5614]

Maxim sir breafing is great and so easy to understand

[@zaynirfan2858]

Thanks a lot for making such an amazing video for Excel learners, God Bless u.

[@Rahul18589]

Sir agar aaap kuch alag se practice fales denge krne ko yaa koi task dege advance excel se related ya excel se related to sir or jyada clear hoga concept aap jaise he teacher ki jurt h humey

[@environmentprotectionorgba5183]

Mere pass ek combined Excel file hai vendor wise main usko alag alag vendor wise Excel sheet karna chahata hoo like 20 vendor 20 Excel sheet alag se unke data according j

[@joykrishnapradhan7062]

Sir Very interesting process.

[@DIPAKDAS-cb9ef]

Sir Combine multiple, you have teach us in such a easy way that I will not forget in the entire life . Thanks sir

[@rehanulfat]

waoo.. kia bat h bhai.. excellent work

[@cute_girl288]

Sir, Thanks for learning. You are the best teacher.

[@narendrarai7656]

Nazim is excellent trainer, also he is very nice and humble person. I had great pleasure talking with Nazim. Thanks Nazim ji.

[@MustafaRaza14]

Great Thank you sir.

[@yamdagami]

wow your very good, i have checked many video but finally i came to know this tips from you channal

[@haneefshaik6179]

Nice sir. Very useful

[@prabalsingh5386]

Very nice Agar heading different ho to kya use kare

[@jeevankumar7467]

Sir i think copy paste jada easy h aisi files k liye.. Agar sir ek hi workbook me 3 sheet me data h aur aisi hi 4 5 sheets hain to unhe kaise merge karenge

[@aeeghaghra5920]

i am also looking for answer of same question but till not find any answer

[@pramodvadnere1563]

HI Sir, This Video really help to me for Merge files in one Excel, Thank You!

[@sandeepdimri8930]

this is the answer what I was seeking. nice sir

[@basayyachannabasayya5949]

Super Sir , I learned so much from this video

[@rrcc6868]

Excellent sir

[@asmrindia]

Nice Sir

[@sureshkumar-pg1ww]

Very nicely explained

[@naveentpentertainments7215]

Hi Sir I want now Same data having in sheet1 and sheet2 when I filter a word in sheet1 it should be select in sheet2 also give answer

[@rajeshshah6758]

Wow! This is going to be very helpful. Thanks Nazim bhai.

[@raagaschoolofmusicschool8185]

i had multiple files with little more columns in some files so copy & paste is not working nazim ji ?

[@shafiqtvs901]

very informative and helpul

[@mohammadhasanuzzaman7369]

Nice Guru

[@RanjeetSinha-ig9tb]

I want to that in an excel file there are 12 sheets having same heading and we want the summary with same heading on next blank sheet means addition of the data of these 12 sheets .what should we do

[@arfanm5166]

Thanks its worked...

[@sukhiparmar]

Sir after consolidation multiple sheet if any changes in perticular sheet then tha data didn't refresh

[@djbeatlover]

Sir is data me agar datewise ho to ham kaise short karenge please make a video about this topic please

[@tabishshakil667]

Good technique

[@shahmohammad7141]

R/Sir i need micro button help of frequency of CDR (CALL DATA RECORD) in ms excel

[@SaurabhSharma-ry8iz]

Sir ye excel 2013 me chal jaayega kya Nice video sir

[@ashokkumargaud9050]

please mention you are referring to which ms office version ??? because there is no Get Data option in Data Tab in 2010 and 2013 too.

[@caharshitarora8709]

Its "power query" add-in. You have to separately download it

[@maneeshyadavyadav4711]

very very nice sir

[@vipulkumarthakur1215]

Hello sir, I am trying to connect two excels from sharedrive, It is running fine in my Computer but giving error when other person (Incorrect File Path)

[@munishmittal9634]

All excel video good

[@bhanvicom.2014]

YOU ARE JUST AWESOME SIR REALLY HELPFUL

[@ashish23039]

Which excel version u r using sir . Plz explain actually we r using excel old version so we dont hve seen this option

[@varungupta3762]

Thank u so much Sir.

[@rajeevgosavi4514]

Well, could you please share a video for combining multiple workbooks into one workbook where entire data is different in all workbooks. Thanks.

[@asmrindia]

Very Nice Sir Thanks Yadi Sheets (Data1, 2 & 3) Me Aage Data Add Karenge To Kya Final Wali Sheet Me Real Time Me Data Update Ho Jayega???

[@joanarun1]

Thankyou apka ❤❤

[@Nilesh-xo1gf]

sir agar exel sheet 3 4 ho or vhi sari sheeto me kaam ak hi kiya ho data same he lekin charo sheet me aadhe aadhe data he to fir un charo sheet ko milake master sheer yani sab data merge kaise kre plz uska vdo bnaye

[@DrSaidurRahaman_PhD]

Thank you Nazim Ji, You shaved my 20 days workload in just one click.

[@kanhucharanmaharana5868]

Get Data option isn't available in my 2010 version... Would you please inform which version of ms office you are working on ?

[@ASHOKPATEL-cn2fn]

Please iska koi reply do ? Same Problem hume hai.

[@subhabratade93]

I was searching this one with out any vba. Thanks najim ji

[@dnyaneshpugaonkar3845]

Excellent

[@balwinder3322]

Very useful information about excel

[@obularajucerisapala8578]

Hi, folder in excel file 1 to 10 is there how to append in one excel sheet kindly suggest to me

[@commerceknowledgehub8922]

This procedures is taking more time compare with Copy paste. Plz confirm yo us, how to creat maceo

[@paycekumar5491]

very good bhai

[@msamidireddy8084]

Sir Is this GET DATA not available in MS OFFICE 2007. WHAT IS THE WAY?

[@AhmedKhan-gs1uv]

It's a brilliant method

[@onlinelearning2744]

excellent tutorial

[@shivaninagar9050]

Could you please tell me how to install ms office 2019 , I tried alot but I am unable to do that , kindly help in this ...

[@swarpati2785]

Hi sir, but mere pass bohat sari excel files hai. jismese i want to select only sheet2 so by selecting one by one it is very difficult. vba code hai kya?

[@MrJack-qu9ej]

Sir everone is telling how to merge data bt no one is telling that how to refer one cell of 1st excel into another excel with the use of hyperlink

[@vinodprashar9366]

Sir, Which excel version you have used to merge multiple files.

[@pramodvadnere1563]

I want to no how to use VLOOKUP function in excel sheet while using Macros functions for different workbook, Could you please help me for this

[@rahulacoustic0075]

Very useful trick,thank you Sir.

[@rabin3333]

Most helpful Sir thanks

[@amritsinghania2722]

Excel khud mey itni badi kitab hai Jo kabhi khatam ni ho sakti 🙏

[@narvirsinhsajubhajadeja1030]

Nazim bhai, I want to know that we have one invoice with 3 items and items release from company item received by us and return empty and company received empty four process but identification number only one how to check all in one Excel

[@business-excel]

Sir I'm not understand your question properly

[@narendrar6563]

for More then 100 files Shall we use this step or We have any other way ?

[@harshitdawar1650]

Will it be automatically updated if I enter any new entry in between?

[@kejal4180]

thank you sirrr. this was a real time saver

[@suzanalfraidi7322]

thanks too much 🙏

[@mukundparanjape2078]

nice sir,

[@JavedIqbal-mk3zt]

Thanks, very excellent explanation of the task.

[@josephvincent.c196]

Thank You! Sharing knowledge is a noble thought.

[@aliabbas4181]

Mere Bhai agar more than 10 sheets hon to kya one by one karaingay?

[@prajwalshetty2047]

Sir I am not able to get the GET DATA option in data tabe in Microsoft office professional 2013, I am not getting option to import data from other workbook. I am not getting the power query option. Please help me out Sir

[@sunilkumar-lg6eg]

I use Excel 2013 wherein get data option not found,how can I get it in Excel 2023,plz guide sir...

[@vijaykumar-zf5ii]

Thanks

[@dhirajpandey6914]

Whether the change in data 1 or 2 or 3 sheet later on will automatically reflect the change is the master sheet? If no then this is useless becoz copying and pasting will save more time than doing this .

[@muhammadshakirnadeem2257]

Can we merge/combine same data format to sum for 12 month

[@ansh-singh]

mujhe attandance sheet se employee ki date of joining find karni mean jis din se wo present ho ...kindly help me

[@alkajain8815]

What if the columns are different and want to merge from different files to different worksheet. Means if I have 3 files work1, work2, work3. I want to create a excel file and in that I should have 3 sheets 1 for works, 1 for work2, and other for work3

[@aakritibhatnagar1991]

Sir, in which excel version I able to find this function, can you let us know.

[@amolkhairnar7094]

Sir GSTR2B KA DATA AGAR rate ke according COLUMNER purchase register mein banan ho to KAISE banaye

[@sumanvijayayande8014]

Thank you very much sir

[@muktiyogabhyas]

Thanks you!

[@dipakthorat5503]

I have a multiple workbooks aroung 40...so any trick to select for all at one time

[@business-excel]

Yes i have made another vdo for that kzbin.info/www/bejne/f3amqYKEYrxkqZY

[@suvendughosh8535]

Sir I am not getting the option Get Data from Data Menu, please help me how to get it.

[@pushpendrasahu1358]

i have no option "from file" how can i apply this process in my excel " home and student 2016"?? please help

[@wafaabano4905]

Is this formula work on seclore file???

[@Lawyer_Saurabh]

Great

[@Castrol-adding-fuel-2-ur-life]

Thank you so much 🙂

[@swetaawasthi7036]

How it is different from copy and paste? Is it link or relative references

[@jyotsanamunjal4443]

same question....

[@syedikramullah1114]

Nazim khan bhai like from pakistan 😘😘😘😘

[@abrarhussain9565]

sir g agr ye teen file jo hm ny imarg krni hn ye agr kis or computer ma hn to hm isy apny system kesy imrage krain gy ya layin gy

[@sridevig4608]

Thank you for sharing this information. It saved a lot of time in my work. 🙏

[@type5737]

I am not getting the option >from workbook, instead from access , from web and others