How To Combine/Consolidate Multiple WORKBOOKS into one in Excel || HINDI
Вставка
- Опубліковано 12 вер 2024
- How To Combine/Consolidate Multiple WORKBOOKS into one in Excel Hindi-
We might need to combine multiple excel workbooks into one workbook in order to analyse or present the information better.if there are a large number of workbooks/worksheets/excel files, then the problem is very bigger. How to easily combine data from multiple workbooks/files in one workbook.
However, we have a solution to this and it would not take more than a few seconds to get all workbooks merged into one. link multiple workbooks into one. We can easily transfer data from multiple excel workbooks/files into a master workbook automatically by link them.
Learn How To consolidate multiple worksheets to a single sheet in excel hindi
• How To Consolidate Dat...
Equipment Used In This Video [You Can Buy]
AMAZON OFFERS:
1.TO BUY - Marantz Professional MPM-1000 Large Diaphragm Condenser Microphone click goo.gl/NdjSQK
2.TO BUY - Generic 57000928MG Silica Gel Professional Condenser Microphone Sound Studio Recording Dynamic (Works With Phantom Power Supply Or Sound Card Only) goo.gl/sRd7RX
3.TO BUY - Blue Yeti USB Microphone, Satin Red Full HD Recording goo.gl/1zSaJ8
Hope you will like the video. Thanks for watching.
-------------------------------------------------------------------
-------------------------------------------------------------------
Subscribe to my channel:
/ deepakeduworld
-------------------------------------------------------------------
-------------------------------------------------------------------
like my facebook page:
/ deepakeduworld
-------------------------------------------------------------------
-------------------------------------------------------------------
follow on linkedin:
/ deepakeduworld
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_____________________________________________________________
MS WORD के videos के लिए ये playlist देखे
• 📰 MS Word 2010 Tutoria...
_____________________________________________________________
ADVANCED MS EXCEL के videos के लिए देखे ये playlists
• 📊 ADVANCED Excel
_____________________________________________________________
ADVANCED MS EXCEL FORMULAS के videos के लिए देखे ये playlists
• ⏹ ADVANCED Excel Formulas
_____________________________________________________________
HTML5 & CSS3 के videos के लिए ये playlist देखे
• ⏹ HTML5 CSS3 Tutorial...
_____________________________________________________________
COMPUTER के TECHNICAL videos के लिए ये playlist देखे
• 📺 Computer Tips & Tricks
_____________________________________________________________
Thanks for Watching
Happy Learning
DEEPAK NEHRA
____________________________________________________________
वैसे आज जो मैने आपकी एक VIDEO देखी COMBINE CONSOLIDATE कि बहुत अच्छा लगा और आपकी समझाने कि शैली बहुत हि पसंद आयी. सहज सरल भाषा में आप जो समझते है बहुत हि जल्दी समझ में आ जाता है.
Sir aapka sikhane ka tarika sebse best h sabkuch samajh me aa jata h... keep it up.... kaash aap mere teacher hote...😍😍
Thank you very much
Perfect Sir.Although I am professional & experience of last 15 years I have no idea about it.Thank u very much 🎉
Sir, I'm from Pakistan 🇵🇰 & I'm big fan of you, I want to ask you something about excel how can I contact you personally, I hope you will give me good response!
Sir... Thanks very nice sir mind blowing sir ....
very nice video
main tumhara video dekh kar ghar par excel sikh raha hun.
+Sanjeev kumar rai 👍👍
you are awesome sir.... but it be outstanding if you will provide practics files of excel .... thank you...
Thank u so much sir... very useful video...
थैंक्स sir ji
Sir I have seen ur video but if we have different sheets whose columns and rows name r different then also this formula works, if not , then pls share another video on this.
Isame agar multiple entry deepak nam se hi hai toh usako ek sheet main kaise kar sakte hai consolidated... Matlab Deepak ki January 1,2,3,4,5 in dates ko bhi sale entry hai jo upar se niche tak hai... To ise kaise kar sakte hai pls tell me
Thanks sirrr
❤❤❤❤❤❤love you guru g
which screen recorder you are using please tell me??
Kya link ki hue file open hone jaruri hai....
Means ke alag alag pc me bethe hue client kabhi bhi data add kare to main file(link file) me update ho jayega ?
Deepak Ji inventory control ki video ka banaige
hello bro,
post a vdo on how to crack MIS interview
Tq for video
Always thank you
Hello, Deepak Ji Thanks for your educational videos. Kindly provide a solution of one query.
I have my customer contact detail in different-2 sheets wherein sheet one customer name and contact detail is available and in another sheet customer email and website is available.For example
Sheet 1 contains = Party Name & Customer Name
Sheet 2 Contains = Contact Numbers Landline and Mobile No.
Sheet 3 contains = Email & website
How do i merge all data in one sheet.
Kinldy provide solution.regards
Good sir
Thank you Sir.
How to print multiple excel files in one folder at a time please suggest me bro 🙏 ❤
thanks deepak nice video
Very thankful for all this vdo r ki66u natun vdo deen
Sir ek question hai jab aap 2nd 3rd 4th 5th or aage wale Row ko Consolidate kiya hai ow to consolidate mai show hi nhi kr raha hai qki aap v srif First Column ka Deepak ki value ka hi Change kiya hai mgr 2nd 3rd 4th 5th or aage wale Row consolidate mai hi nhi kar raha hai bich ki value like Aman, Anil Rohit ka to show hi nahi ho raha hai ek Alag excel workbook mai to kaise Consolidate kare.
sir please post regarding google sheet to excel import video
Awesome sir👍
Super Sir
Excel file ko word file se kaise joint kare jo excel me change kare wo word me ho jaye
Sir I have a question if we have 3 schemes of 50 districts.... like in scheme 1 we have data in only 10 district(only 10 names are written in table other 40 are missing)... 20 in other and 50 districts in scheme 3..... how to combine data like column 1 district.... colum 2- scheme 1, column 3-scheme 2 and col 4 sccheme 3.... and total district 50..... and if data is not present of any district in any scheme it take zero in front automatically.... is it possible please help
Very nice tutorial sir
bro yearly payroll kaise consolidate kare each staff ke liye
jan to dec
Good
Wah Guru- thanks
😊
Nice very good sar thanks àapke liye aasan hai sar
Very very good tricks
Thanks bhai 👍
Very useful
Excel me formal letter paragraph kese banaye
I think cannot be done in the 2007 version. Right!
SIR MUJHE MULTIPLE SHEETS SE KUCHH CONTAINT KO EK NEW WORKBOOK OR WORKSHEET ME LINK KARANA HAI MAGAR IS TARAH SE KI AGAR US FILE KA PATH CHANGE HOTA HAI YAAR VO DATA MERE PC SE COPY KARKE KISI AUR PC ME DALA JAYE TO SHAME FUNCTIONS AUTO MODE PE WORK KARe kya meri help kar sakte hai
Superb
Wow sir thanks
Best hai sir
sir thanks for the video....but data consolidate Macros se kaise kare, mere pas 50+ files hai, so not possible to open 50 files at a time...pls help
Yes, Good question u ask brother.HV u get the solve if yes plz upload
Nice video
Good night sir,
Deepak ji,
Agar left column me jo name list h vo tino excel sheet me alag-alag ho to, Means hame data sum/average nhi krna balki tino excel sheet ka data combine krna h, Copy- Paste k alava koi aur method btao bcuz no. of files jyda ho skti h 100 tak v ho skti h so itna copy past to nhi kr skte na sabhi 100 sheets ka data ek sheet me lane k liye.
Plz reply
+rajendra sain okay i will publish video as soon as possible
please reply
Agr ek saath 80 worksheets ko consolidate krna ho to.. kaise krenge? 80 files opne krni pdegi?
Deepak Sir,
नीचे Total वाला range नहीं लिया, क्या वो उन sheets के साथ लेना है या अलग से?
+Puneet Vij u can select the whole data...
Thanks
Good information, thank you
So nice information 👌👌👍👍
sir mera paas ek bhot data hai ume muje jo colums pending uss row ka data chahiye means wo puri roe ka data aa jye plz video bnao to mje link share karna office me chahiye
Hello sir I have a question
Jese ki ek file me humne kon Kitna kaam ki he sare data bogera he (Jese ki finance data) ese 10/15/20 log ki kaam ki data he mujhe dusre koi file ya sheet 2 me Har ek worker ki kaam ki % nikalna ho Esa koi formula he kya... Please help....
Mujhe sab file ko ek master file banake usme se mob no khojna hai to fir consolidate dialogue box mai kya choose karu count
Nice video. Sir gpa calculator or vba in excel ka video upload kar do na
Thanks... I will publish vba tutorials shortly
Great
Do values ko milakar vlook-up ya index match kaise karenge i.e. PGMA 04200 DU No. 01 mein balance stock pata karna hai, PGMA 04200 mein bahut saare DU No. ho sakte hain.
i am regular views of your channel .could u upload the video of case sensitive
Ya sure..please wait
Very nice
How to multi sheets files that all merge in new sheet in one file Pls. intimate
Awesome work man. Keep it up
Thanks ..but how to delete the consolidated column and row ...data can be deleted but linking is there🤔
Deepak sir,
Muje ek question hai... Sir Mene apka 10 Mobile NUM digit validation wala video Dekha. Usme me 9 or 11 digit Ka mobile enter karta hu to alert start hai but jab me koi dusre cell se 8/9/4/5/12 digit Ka number us mobile vala validation k cell me paste karta hu to alert msg Nahi ata hai bulki number valid ho jata hai. So please tell me why this happened bcz we already set the validation in mobile number.
+Ketan Prajapati okay.. I will check it.. And revert to u very shortly
Sir ye asan to hai par isska istmal kahan aur kis chz kliye hota hai plz bataye
Sir aagar 1 sheet main humne single text 4 coulam main type keya hai or dusri sheet main same text 6 coulam main link karna hai to muhje kya karna hoga.....
Excel ki ek workbook me 50 sheets par kaam kiye hai to un sabhi sheets ka list dekh sakte hai or print de sakte hai kya ? Kewal sheets name ka.
Kindly bataye
Sir developer tap Kay sbhi function Kay bry may btaiy. Kiya Kiya kam krty hai
hi deepak,
I want to make a dynamic report for stock request ,from SOH (Stock on hand ) and auto replishment.
YTD vs Last YTD with dynamic chart
Sir, mein aik worksheet ki entry same 2, 3 worksheets mein save karna chahata hon
Deepak ji ek sheet ke data Ko split karke different sheets par kaise le ja sakte hai, if any formula tell me plz
Sir create link source inactive please solve
Behtreen
Kya isko save karna jaroori hain
Sir how we can reconcile debit equals to credit can u make one sheet for reconciliation for different amounts.
How to merge multiple worksheet
Sir ek sheet main two table hain ( dono table ko ek Krna hain plus minus ke sath) usko ek hi table main kaise convert Krna hai please botao
Nice video ji
2007 mai hoga?
Sir mene aapka consolidated program dekha or shikh mager name add karna hai to kiya kare
Sir,ek doubt, 2 excel sheet he,1 me customer name,and customer code, 2nd sheet me customer code, konsi formula use karke jisme sirf customer code he usme customer name ko lana hai,pls reply sir
nice
Sir ms word ke chart smart art ka format ka use pls bta doh
Sir if we close this sheet where the datas were inserted and we bring change in another three sheets and than we open this source sheet and the change will come
Sir ek master stock list m part wise stock sheet kaise jode taki jo alag alag stock sheet banayi h stock wo stock automatically master stock maintain hota rahe
दीपक जी नमस्ते. मुझे EXCEL में cash बुक में data एन्ट्री करने के बाद हर एक एन्ट्री उस PARTICULAR LEDGER में AUTOMATIC पोस्ट हो जाना चाहिये कृपया वो कैसे हो पायेगा मार्गदर्शन करिये ऐसी आपसे बिनती है. उसमें फिर ओपनिंग BALANCE से लेकर DEBIT और CREDIT दोनो SIDE कि एन्ट्री उस खाते में शिफ्ट करना है. ता कि मुझे cash BOOK से MANUALY वो एन्ट्री खाते में डालने कि जरुरत नाहीन पड्नी चाहिये.
If 3 excel sheet included in one excel sheet then how to we can take 3 different file form 1 excel sheet
Can this work on the file stored on network? Means multiple users editing it and it disply it on main workbook
ua-cam.com/video/6sUFp9m5sz0/v-deo.html
@@DeepakEduWorld thank uh
After consolidate when i want to delete data that is not delet, Pls give any solution for it.
Sir meine 1 report nikal monthy 15 mint k diley time sw... Phr mujhe abb usey 1 hour mein concert krna h.. Tw 1 1 row dlet krta hn tw 2hrs lg jate h... Koi aassan haL btye.. Jis mein 15'30'45 wali rows dlet hojye or 1 hrs wle rhe
Agar meri source data file closed h.. aur usme automatically data update ho rha h to.. vo update other excel file me bhi ho.. Uske uper koi video banao na..
If data is different in different sheet then????
hello deepak ji, i have excel sheet data with the images just like quotation , how to merge , as this formula dosent work for me
Data me kisi ek chij ka same hone compulsory h kya sir. Do not like reply only written reply.
You can consolidate same data
I saw, in consolidation sheet data is consolidating leaving 1 column blank from left most column . Why ? Please explain. And other columns are shrinking.
Nice tricks,but you are finishing quickly if you explain slowly and clearly, we can understand, otherwise nice
Hi deekpak unable to import data form Excel to access