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
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
2 жыл бұрын
💞👌🏼
@ramanjeet1111
2 жыл бұрын
IZ THERE AN ONLINE WEBSITE WHERE I CAN RUN VBA CODES......AND IT WILL CORRECT ME ACCORDINGLY
@dharmendravishwakarma4947
2 жыл бұрын
It's possible to update automatically
@gursewaksingh7570
Жыл бұрын
How to consolidate all four quarter return data ( from four different sheets) for annual return
Thank You! Sharing knowledge is a noble thought.
Thank you for sharing this information. It saved a lot of time in my work. 🙏
sir i have watched many videos but you are the best one
Sir, Thanks for learning. You are the best teacher.
Nazim is excellent trainer, also he is very nice and humble person. I had great pleasure talking with Nazim. Thanks Nazim ji.
Excellant. I have been looking for this.
this is the answer what I was seeking. nice sir
Wow! This is going to be very helpful. Thanks Nazim bhai.
Thanks, very excellent explanation of the task.
Super Sir , I learned so much from this video
HI Sir, This Video really help to me for Merge files in one Excel, Thank You!
wow your very good, i have checked many video but finally i came to know this tips from you channal
Sir I swear ur the best ..Allah bless u always
Thanks a lot for making such an amazing video for Excel learners, God Bless u.
बहुत अच्छा विडियो है सर ।
YOU ARE JUST AWESOME SIR REALLY HELPFUL
thank you sirrr. this was a real time saver
Most helpful Sir thanks
Maxim sir breafing is great and so easy to understand
Simply beautiful! Liked it very much. HC ARORA
Superb It's help a lot in my work
Thanks it's interesting !
Very useful trick,thank you Sir.
waoo.. kia bat h bhai.. excellent work
Great Thank you sir.
verry easy to understand, thanku sir
Thanks its worked...
Very useful information about excel
Thankyou apka ❤❤
Thanks for this videos......
Thank you so much.
Thank u so much Sir.
Nice sir. Very useful
Sir Very interesting process.
Excellent sir
It's a brilliant method
Thank you very much sir
very informative and helpul
Very informative
Very nicely explained
Thanks a lot.
Excellent video
Thanks you!
Nice Guru
Thank you Nazim Ji, You shaved my 20 days workload in just one click.
Your are great
Thank you so much 🙂
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
excellent tutorial
thanks too much 🙏
very very nice sir
Good technique
Excellent
All excel video good
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
nice sir,
EXCELLENT
very good bhai
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???
Great
Thanks
Amazing
Nice Sir
Buhat achay
thanks
Sir, how to combine if we have different columns and common rows?
Sir, Which excel version you have used to merge multiple files.
I was searching this one with out any vba. Thanks najim ji
Which excel version u r using sir . Plz explain actually we r using excel old version so we dont hve seen this option
I have done from this technique and merged 20,000 data In excel..thank you so much for this..
@business-excel
Жыл бұрын
Great 👍
Well, could you please share a video for combining multiple workbooks into one workbook where entire data is different in all workbooks. Thanks.
Sir, in which excel version I able to find this function, can you let us know.
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
Very nice Agar heading different ho to kya use kare
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
Make video on custome formatting with rules
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
Жыл бұрын
Thx❤
Ok sir
सुप्रभात
Sir I watched the full video and practiced it . But it's not working on sheets which contains large valumes of data.
Sir Combine multiple, you have teach us in such a easy way that I will not forget in the entire life . Thanks sir
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)
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
Hi, folder in excel file 1 to 10 is there how to append in one excel sheet kindly suggest to me
Nazim khan bhai like from pakistan 😘😘😘😘
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
2 жыл бұрын
Its "power query" add-in. You have to separately download it
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
R/Sir i need micro button help of frequency of CDR (CALL DATA RECORD) in ms excel
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
3 жыл бұрын
i am also looking for answer of same question but till not find any answer
What to do if data fields are different and we want to merge it?
Kindly make video on split one excel data into multiple excel
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 ...
💞👌🏼
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
Sir after consolidation multiple sheet if any changes in perticular sheet then tha data didn't refresh
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
i had multiple files with little more columns in some files so copy & paste is not working nazim ji ?
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
does it works with excel 2016