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

Поділитися
Вставка
  • Опубліковано 25 сер 2024
  • 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) UA-cam
    🔴 / techguruplusindia
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    Contact for Business Inquiry :
    ✉ info@TechGuruPlus.com
    ✉ nazim.khan09@gmail.com
    Channel Owner: Nazim Khan
    🏆 Experience: 10 Years+
    ⏳ Website : ► www.TechGuruPlu...
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    #TechGuruPlus #NazimKhan

КОМЕНТАРІ • 300

  • @business-excel
    @business-excel  4 роки тому +7

    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 3 роки тому +1

      💞👌🏼

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

  • @ndtiwariii
    @ndtiwariii Рік тому +1

    verry easy to understand, thanku sir

  • @joanarun1
    @joanarun1 Рік тому

    Thankyou apka ❤❤

  • @rajibroy5614
    @rajibroy5614 2 роки тому +1

    Maxim sir breafing is great and so easy to understand

  • @PravinKumar-we3bq
    @PravinKumar-we3bq 4 роки тому

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

  • @munishmittal9634
    @munishmittal9634 3 роки тому

    All excel video good

  • @kamalkoli8937
    @kamalkoli8937 Рік тому +1

    Superb
    It's help a lot in my work

  • @sportsdriver
    @sportsdriver 2 роки тому

    Excellent video

  • @maneeshyadavyadav4711
    @maneeshyadavyadav4711 2 роки тому

    very very nice sir

  • @joykrishnapradhan7062
    @joykrishnapradhan7062 Рік тому +1

    Sir Very interesting process.

  • @sandeepdimri8930
    @sandeepdimri8930 4 роки тому +2

    this is the answer what I was seeking. nice sir

  • @MustafaRaza14
    @MustafaRaza14 Рік тому +1

    Great Thank you sir.

  • @tabishshakil667
    @tabishshakil667 Рік тому

    Good technique

  • @haneefshaik6179
    @haneefshaik6179 Рік тому +1

    Nice sir. Very useful

  • @varungupta3762
    @varungupta3762 2 роки тому

    Thank u so much Sir.

  • @paycekumar5491
    @paycekumar5491 3 роки тому

    very good bhai

  • @arfanm5166
    @arfanm5166 Рік тому

    Thanks its worked...

  • @pappujoshi5219
    @pappujoshi5219 3 роки тому

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

  • @swatitoliya5036
    @swatitoliya5036 Рік тому +1

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

  • @rehanulfat
    @rehanulfat 2 роки тому

    waoo.. kia bat h bhai.. excellent work

  • @dnyaneshpugaonkar3845
    @dnyaneshpugaonkar3845 2 роки тому

    Excellent

  • @armaanansari2805
    @armaanansari2805 2 роки тому

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

  • @suzanalfraidi7322
    @suzanalfraidi7322 Рік тому

    thanks too much 🙏

  • @shafiqtvs901
    @shafiqtvs901 9 місяців тому

    very informative and helpul

  • @huzaifahshah3841
    @huzaifahshah3841 3 роки тому

    Buhat achay

  • @mukundparanjape2078
    @mukundparanjape2078 3 роки тому

    nice sir,

  • @cute_girl288
    @cute_girl288 2 роки тому

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

  • @basayyachannabasayya5949
    @basayyachannabasayya5949 3 роки тому +1

    Super Sir , I learned so much from this video

  • @zaynirfan2858
    @zaynirfan2858 6 місяців тому

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

  • @vijaykumar-zf5ii
    @vijaykumar-zf5ii Рік тому

    Thanks

  • @sureshkumar-pg1ww
    @sureshkumar-pg1ww Рік тому

    Very nicely explained

  • @yamdagami
    @yamdagami 3 роки тому

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

  • @asmrindia
    @asmrindia 3 роки тому +1

    Nice Sir

  • @Lawyer_Saurabh
    @Lawyer_Saurabh 2 роки тому

    Great

  • @rrcc6868
    @rrcc6868 2 роки тому

    Excellent sir

  • @chandrakantmalapur9659
    @chandrakantmalapur9659 2 роки тому

    EXCELLENT

  • @syedikramullah1114
    @syedikramullah1114 2 роки тому

    Very informative

  • @balwinder3322
    @balwinder3322 4 роки тому

    Very useful information about excel

  • @prabalsingh5386
    @prabalsingh5386 2 роки тому

    Very nice
    Agar heading different ho to kya use kare

  • @iamnotgoodkate
    @iamnotgoodkate 2 роки тому

    thanks

  • @bhanvicom.2014
    @bhanvicom.2014 4 роки тому

    YOU ARE JUST AWESOME SIR
    REALLY HELPFUL

  • @narendrarai7656
    @narendrarai7656 3 роки тому +1

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

  • @rabin3333
    @rabin3333 4 роки тому

    Most helpful Sir thanks

  • @pramodvadnere1563
    @pramodvadnere1563 2 роки тому

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

  • @rajeshshah6758
    @rajeshshah6758 2 роки тому

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

  • @kejal4180
    @kejal4180 2 роки тому

    thank you sirrr. this was a real time saver

  • @AhmedKhan-gs1uv
    @AhmedKhan-gs1uv 4 роки тому

    It's a brilliant method

  • @rahulacoustic0075
    @rahulacoustic0075 4 роки тому

    Very useful trick,thank you Sir.

  • @onlinelearning2744
    @onlinelearning2744 3 роки тому

    excellent tutorial

  • @mohammadhasanuzzaman7369
    @mohammadhasanuzzaman7369 3 роки тому

    Nice Guru

  • @environmentprotectionorgba5183
    @environmentprotectionorgba5183 10 місяців тому +1

    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

  • @sumanvijayayande8014
    @sumanvijayayande8014 3 роки тому

    Thank you very much sir

  • @RakeshKumar-cf2su
    @RakeshKumar-cf2su Рік тому

    सुप्रभात

  • @jeevankumar7467
    @jeevankumar7467 4 роки тому +9

    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 4 роки тому +2

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

  • @muktiyogabhyas
    @muktiyogabhyas 2 роки тому

    Thanks you!

  • @djbeatlover
    @djbeatlover Рік тому

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

  • @FUNNYARCHIT
    @FUNNYARCHIT 3 роки тому

    Thanks a lot.

  • @Castrol-adding-fuel-2-ur-life
    @Castrol-adding-fuel-2-ur-life 2 роки тому

    Thank you so much 🙂

  • @ABDULHAMEED-nw1fy
    @ABDULHAMEED-nw1fy 4 роки тому

    Your are great

  • @JavedIqbal-mk3zt
    @JavedIqbal-mk3zt 3 роки тому

    Thanks, very excellent explanation of the task.

  • @DrSaidurRahaman_PhD
    @DrSaidurRahaman_PhD 2 роки тому

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

  • @mohammedjunaidofficial8321
    @mohammedjunaidofficial8321 3 роки тому

    Thanks it's interesting !

  • @mahmodulhasan6378
    @mahmodulhasan6378 4 роки тому

    Thanks for this videos......

  • @hcarora
    @hcarora 4 роки тому

    Simply beautiful! Liked it very much. HC ARORA

  • @amritsinghania2722
    @amritsinghania2722 3 роки тому

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

  • @shahmohammad7141
    @shahmohammad7141 3 місяці тому

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

  • @Rahul18589
    @Rahul18589 4 роки тому

    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

  • @hooprmoto5669
    @hooprmoto5669 2 роки тому

    You can ron de bruin merge template

  • @bikashshaw6994
    @bikashshaw6994 Рік тому +3

    Agar samjh na aaye aur 1 hi sheet me data ho to aap copy krke kisi ek sheet me paste kr le sabse easy 😂

  • @josephvincent.c196
    @josephvincent.c196 3 роки тому

    Thank You! Sharing knowledge is a noble thought.

  • @farhanuddin9328
    @farhanuddin9328 4 роки тому

    Thank you so much.

  • @syedikramullah1114
    @syedikramullah1114 4 роки тому

    Nazim khan bhai like from pakistan 😘😘😘😘

  • @kamalgupta25
    @kamalgupta25 4 роки тому

    Excellant. I have been looking for this.

  • @SaurabhSharma-ry8iz
    @SaurabhSharma-ry8iz Рік тому

    Sir ye excel 2013 me chal jaayega kya
    Nice video sir

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

  • @sridevig4608
    @sridevig4608 3 роки тому

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

  • @pa2happiness13
    @pa2happiness13 3 роки тому +1

    💞👌🏼

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

  • @sukhiparmar
    @sukhiparmar Рік тому

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

  • @manjit.sarania
    @manjit.sarania 2 роки тому

    Ok sir

  • @asmrindia
    @asmrindia 4 роки тому +1

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

  • @priyankalodhi2427
    @priyankalodhi2427 4 роки тому

    Amazing

  • @subhabratade93
    @subhabratade93 4 роки тому

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

  • @commerceknowledgehub8922
    @commerceknowledgehub8922 3 роки тому

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

  • @mukundparanjape2078
    @mukundparanjape2078 3 роки тому

    does it works with excel 2016

  • @JitendraKumar-gm3fk
    @JitendraKumar-gm3fk 3 роки тому

    Special character problems ko kese solve karte hai. Sir

  • @manojsolanki9546
    @manojsolanki9546 Рік тому

    Excel me hi dekhna chahenhw

  • @Nilesh-xo1gf
    @Nilesh-xo1gf 3 роки тому

    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

  • @ashokkumargaud9050
    @ashokkumargaud9050 3 роки тому +2

    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

  • @amolkhairnar7094
    @amolkhairnar7094 9 місяців тому

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

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

  • @NaughtyShaurya007
    @NaughtyShaurya007 2 роки тому

    I thik it's better to do copy paste, because it's taking same time

  • @raagaschoolofmusicschool8185

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

  • @rajeevgosavi4514
    @rajeevgosavi4514 11 місяців тому

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

  • @tumitshriwas
    @tumitshriwas 8 місяців тому

    shorcut process pls

  • @deepakupreti8846
    @deepakupreti8846 4 роки тому

    Kindly make video on split one excel data into multiple excel

  • @kanhucharanmaharana5868
    @kanhucharanmaharana5868 3 роки тому +2

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

  • @type5737
    @type5737 Рік тому

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

  • @praveshdeshwal695
    @praveshdeshwal695 4 роки тому

    Make video on custome formatting with rules

  • @cute_girl288
    @cute_girl288 2 роки тому

    Hello sir