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.techguruplus.com/merge-com...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉 Buy Excel Course: - TechGuruPlus.com/Excel-Course/
👉 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) KZread
🔴 / techguruplusindia
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Contact for Business Inquiry :
✉ info@TechGuruPlus.com
✉ nazim.khan09@gmail.com
Channel Owner: Nazim Khan
🏆 Experience: 10 Years+
⏳ Website : ► www.TechGuruPlus.com
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
#TechGuruPlus #NazimKhan

Пікірлер: 296

  • @business-excel
    @business-excel4 жыл бұрын

    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

    @pa2happiness13

    2 жыл бұрын

    💞👌🏼

  • @ramanjeet1111

    @ramanjeet1111

    2 жыл бұрын

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

  • @dharmendravishwakarma4947

    @dharmendravishwakarma4947

    2 жыл бұрын

    It's possible to update automatically

  • @gursewaksingh7570

    @gursewaksingh7570

    Жыл бұрын

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

  • @josephvincent.c196
    @josephvincent.c1963 жыл бұрын

    Thank You! Sharing knowledge is a noble thought.

  • @sridevig4608
    @sridevig46083 жыл бұрын

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

  • @PravinKumar-we3bq
    @PravinKumar-we3bq4 жыл бұрын

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

  • @cute_girl288
    @cute_girl2882 жыл бұрын

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

  • @narendrarai7656
    @narendrarai76563 жыл бұрын

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

  • @kamalgupta25
    @kamalgupta254 жыл бұрын

    Excellant. I have been looking for this.

  • @sandeepdimri8930
    @sandeepdimri89304 жыл бұрын

    this is the answer what I was seeking. nice sir

  • @rajeshshah6758
    @rajeshshah67582 жыл бұрын

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

  • @JavedIqbal-mk3zt
    @JavedIqbal-mk3zt2 жыл бұрын

    Thanks, very excellent explanation of the task.

  • @basayyachannabasayya5949
    @basayyachannabasayya59493 жыл бұрын

    Super Sir , I learned so much from this video

  • @pramodvadnere1563
    @pramodvadnere15632 жыл бұрын

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

  • @yamdagami
    @yamdagami3 жыл бұрын

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

  • @armaanansari2805
    @armaanansari28052 жыл бұрын

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

  • @zaynirfan2858
    @zaynirfan28585 ай бұрын

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

  • @pappujoshi5219
    @pappujoshi52193 жыл бұрын

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

  • @paricom.2018
    @paricom.20183 жыл бұрын

    YOU ARE JUST AWESOME SIR REALLY HELPFUL

  • @kejal4180
    @kejal41802 жыл бұрын

    thank you sirrr. this was a real time saver

  • @rabin3333
    @rabin33334 жыл бұрын

    Most helpful Sir thanks

  • @rajibroy5614
    @rajibroy56142 жыл бұрын

    Maxim sir breafing is great and so easy to understand

  • @hcarora
    @hcarora4 жыл бұрын

    Simply beautiful! Liked it very much. HC ARORA

  • @kamalkoli8937
    @kamalkoli8937 Жыл бұрын

    Superb It's help a lot in my work

  • @mohammedjunaidofficial8321
    @mohammedjunaidofficial83213 жыл бұрын

    Thanks it's interesting !

  • @rahulacoustic0075
    @rahulacoustic00754 жыл бұрын

    Very useful trick,thank you Sir.

  • @rehanulfat
    @rehanulfat2 жыл бұрын

    waoo.. kia bat h bhai.. excellent work

  • @MustafaRaza14
    @MustafaRaza14 Жыл бұрын

    Great Thank you sir.

  • @ndtiwariii
    @ndtiwariii Жыл бұрын

    verry easy to understand, thanku sir

  • @arfanm5166
    @arfanm5166 Жыл бұрын

    Thanks its worked...

  • @balwinder3322
    @balwinder33224 жыл бұрын

    Very useful information about excel

  • @joanarun1
    @joanarun1 Жыл бұрын

    Thankyou apka ❤❤

  • @mahmodulhasan6378
    @mahmodulhasan63784 жыл бұрын

    Thanks for this videos......

  • @farhanuddin9328
    @farhanuddin93283 жыл бұрын

    Thank you so much.

  • @varungupta3762
    @varungupta37622 жыл бұрын

    Thank u so much Sir.

  • @haneefshaik6179
    @haneefshaik6179 Жыл бұрын

    Nice sir. Very useful

  • @joykrishnapradhan7062
    @joykrishnapradhan7062 Жыл бұрын

    Sir Very interesting process.

  • @rrcc6868
    @rrcc68682 жыл бұрын

    Excellent sir

  • @AhmedKhan-gs1uv
    @AhmedKhan-gs1uv4 жыл бұрын

    It's a brilliant method

  • @sumanvijayayande8014
    @sumanvijayayande80143 жыл бұрын

    Thank you very much sir

  • @shafiqtvs901
    @shafiqtvs9018 ай бұрын

    very informative and helpul

  • @syedikramullah1114
    @syedikramullah11142 жыл бұрын

    Very informative

  • @sureshkumar-pg1ww
    @sureshkumar-pg1ww Жыл бұрын

    Very nicely explained

  • @FUNNYARCHIT
    @FUNNYARCHIT3 жыл бұрын

    Thanks a lot.

  • @sportsdriver
    @sportsdriver2 жыл бұрын

    Excellent video

  • @muktiyogabhyas
    @muktiyogabhyas2 жыл бұрын

    Thanks you!

  • @mohammadhasanuzzaman7369
    @mohammadhasanuzzaman73693 жыл бұрын

    Nice Guru

  • @DrSaidurRahaman_PhD
    @DrSaidurRahaman_PhD2 жыл бұрын

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

  • @ABDULHAMEED-nw1fy
    @ABDULHAMEED-nw1fy4 жыл бұрын

    Your are great

  • @Castrol-adding-fuel-2-ur-life
    @Castrol-adding-fuel-2-ur-life2 жыл бұрын

    Thank you so much 🙂

  • @Rahul18589
    @Rahul185894 жыл бұрын

    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

  • @onlinelearning2744
    @onlinelearning27443 жыл бұрын

    excellent tutorial

  • @suzanalfraidi7322
    @suzanalfraidi7322 Жыл бұрын

    thanks too much 🙏

  • @maneeshyadavyadav4711
    @maneeshyadavyadav47112 жыл бұрын

    very very nice sir

  • @tabishshakil667
    @tabishshakil667 Жыл бұрын

    Good technique

  • @dnyaneshpugaonkar3845
    @dnyaneshpugaonkar38452 жыл бұрын

    Excellent

  • @munishmittal9634
    @munishmittal96343 жыл бұрын

    All excel video good

  • @alkajain8815
    @alkajain88153 жыл бұрын

    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

  • @mukundparanjape2078
    @mukundparanjape20783 жыл бұрын

    nice sir,

  • @chandrakantmalapur9659
    @chandrakantmalapur96592 жыл бұрын

    EXCELLENT

  • @paycekumar5491
    @paycekumar54913 жыл бұрын

    very good bhai

  • @asmrindia
    @asmrindia4 жыл бұрын

    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???

  • @Lawyer_Saurabh
    @Lawyer_Saurabh2 жыл бұрын

    Great

  • @vijaykumar-zf5ii
    @vijaykumar-zf5ii Жыл бұрын

    Thanks

  • @priyankalodhi2427
    @priyankalodhi24274 жыл бұрын

    Amazing

  • @asmrindia
    @asmrindia3 жыл бұрын

    Nice Sir

  • @huzaifahshah3841
    @huzaifahshah38413 жыл бұрын

    Buhat achay

  • @iamnotgoodkate
    @iamnotgoodkate2 жыл бұрын

    thanks

  • @hrstrong6314
    @hrstrong63143 жыл бұрын

    Sir, how to combine if we have different columns and common rows?

  • @vinodprashar9366
    @vinodprashar93663 жыл бұрын

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

  • @subhabratade93
    @subhabratade934 жыл бұрын

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

  • @ashish23039
    @ashish230394 жыл бұрын

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

  • @swatitoliya5036
    @swatitoliya5036 Жыл бұрын

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

  • @business-excel

    @business-excel

    Жыл бұрын

    Great 👍

  • @rajeevgosavi4514
    @rajeevgosavi451410 ай бұрын

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

  • @aakritibhatnagar1991
    @aakritibhatnagar19913 жыл бұрын

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

  • @RanjeetSinha-ig9tb
    @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

  • @prabalsingh5386
    @prabalsingh53862 жыл бұрын

    Very nice Agar heading different ho to kya use kare

  • @pramodvadnere1563
    @pramodvadnere15632 жыл бұрын

    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

  • @praveshdeshwal695
    @praveshdeshwal6954 жыл бұрын

    Make video on custome formatting with rules

  • @mrCetus
    @mrCetus2 жыл бұрын

    Sir, Is it possible to extract/get common things from 2-3 Excel sheets. Eg:- Sht.1 - XYZ - 10 QTY. Sht.2 - XYZ - 5 QTY. Sht.3 - XYZ - 105 QTY.

  • @exampaperap9624

    @exampaperap9624

    Жыл бұрын

    Thx❤

  • @manjit.sarania
    @manjit.sarania Жыл бұрын

    Ok sir

  • @RakeshKumar-cf2su
    @RakeshKumar-cf2su Жыл бұрын

    सुप्रभात

  • @penchalreddy8332
    @penchalreddy83323 жыл бұрын

    Sir I watched the full video and practiced it . But it's not working on sheets which contains large valumes of data.

  • @DIPAKDAS-cb9ef
    @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

  • @vipulkumarthakur1215
    @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)

  • @naveentpentertainments7215
    @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

  • @obularajucerisapala8578
    @obularajucerisapala8578 Жыл бұрын

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

  • @syedikramullah1114
    @syedikramullah11144 жыл бұрын

    Nazim khan bhai like from pakistan 😘😘😘😘

  • @ashokkumargaud9050
    @ashokkumargaud90503 жыл бұрын

    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

    @caharshitarora8709

    2 жыл бұрын

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

  • @prajwalshetty2047
    @prajwalshetty20472 жыл бұрын

    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

  • @shahmohammad7141
    @shahmohammad71412 ай бұрын

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

  • @jeevankumar7467
    @jeevankumar74674 жыл бұрын

    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

    @aeeghaghra5920

    3 жыл бұрын

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

  • @archanaprabhune6036
    @archanaprabhune60363 жыл бұрын

    What to do if data fields are different and we want to merge it?

  • @deepakupreti8846
    @deepakupreti88464 жыл бұрын

    Kindly make video on split one excel data into multiple excel

  • @shivaninagar9050
    @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 ...

  • @pa2happiness13
    @pa2happiness132 жыл бұрын

    💞👌🏼

  • @abrarhussain9565
    @abrarhussain95653 жыл бұрын

    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

  • @sukhiparmar
    @sukhiparmar Жыл бұрын

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

  • @environmentprotectionorgba5183
    @environmentprotectionorgba51839 ай бұрын

    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

  • @raagaschoolofmusicschool8185
    @raagaschoolofmusicschool8185 Жыл бұрын

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

  • @Nilesh-xo1gf
    @Nilesh-xo1gf2 жыл бұрын

    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

  • @mukundparanjape2078
    @mukundparanjape20783 жыл бұрын

    does it works with excel 2016

Келесі