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
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
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
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
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
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)
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
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
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 .
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
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
💞👌🏼
IZ THERE AN ONLINE WEBSITE WHERE I CAN RUN VBA CODES......AND IT WILL CORRECT ME ACCORDINGLY
It's possible to update automatically
How to consolidate all four quarter return data ( from four different sheets) for annual return
I have done from this technique and merged 20,000 data In excel..thank you so much for this..
Great 👍
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
Superb
It's help a lot in my work
sir i have watched many videos but you are the best one
बहुत अच्छा विडियो है सर ।
verry easy to understand, thanku sir
waoo.. kia bat h bhai.. excellent work
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
i am also looking for answer of same question but till not find any answer
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???
Maxim sir breafing is great and so easy to understand
Thanks a lot for making such an amazing video for Excel learners, God Bless u.
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
Sir copy paste bho to kr sakte hai agar same format hai
Sir I swear ur the best ..Allah bless u always
Sir ye excel 2013 me chal jaayega kya
Nice video sir
R/Sir i need micro button help of frequency of CDR (CALL DATA RECORD) in ms excel
Great Thank you sir.
Copy paste bhi kr sakte hai new sheet bnakr
Nice sir. Very useful
Mere Bhai agar more than 10 sheets hon to kya one by one karaingay?
wow your very good, i have checked many video but finally i came to know this tips from you channal
Super Sir , I learned so much from this video
this is the answer what I was seeking. nice sir
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.
Its "power query" add-in. You have to separately download it
Sir GSTR2B KA DATA AGAR rate ke according COLUMNER purchase register mein banan ho to KAISE banaye
Excel khud mey itni badi kitab hai
Jo kabhi khatam ni ho sakti 🙏
very informative and helpul
Nazim is excellent trainer, also he is very nice and humble person. I had great pleasure talking with Nazim. Thanks Nazim ji.
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
Sir, Thanks for learning.
You are the best teacher.
HI Sir, This Video really help to me for Merge files in one Excel, Thank You!
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
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
mujhe attandance sheet se employee ki date of joining find karni mean jis din se wo present ho ...kindly help me
i had multiple files with little more columns in some files so copy & paste is not working nazim ji ?
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
Thanks its worked...
Well, could you please share a video for combining multiple workbooks into one workbook where entire data is different in all workbooks. Thanks.
Sir after consolidation multiple sheet if any changes in perticular sheet then tha data didn't refresh
This procedures is taking more time compare with Copy paste.
Plz confirm yo us, how to creat maceo
Excellent sir
ye tu copy paste se b kr skty hai
Which excel version u r using sir . Plz explain actually we r using excel old version so we dont hve seen this option
Wow! This is going to be very helpful. Thanks Nazim bhai.
I have a multiple workbooks aroung 40...so any trick to select for all at one time
Yes i have made another vdo for that
ua-cam.com/video/IECxON-W1s4/v-deo.html
Hi, folder in excel file 1 to 10 is there how to append in one excel sheet kindly suggest to me
Bhai mein ne aesey hi kia data to aagia magar pehla column nahi aaya... jo ke item code tha. description sr pehley.. is ka kia solution hai??
Get Data option isn't available in my 2010 version... Would you please inform which version of ms office you are working on ?
Please iska koi reply do ? Same Problem hume hai.
Thank you Nazim Ji, You shaved my 20 days workload in just one click.
Very nicely explained
Sir
Is this GET DATA not available in MS OFFICE 2007.
WHAT IS THE WAY?
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 Combine multiple, you have teach us in such a easy way that I will not forget in the entire life . Thanks sir
Very useful information about excel
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)
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 is data me agar datewise ho to ham kaise short karenge please make a video about this topic please
YOU ARE JUST AWESOME SIR
REALLY HELPFUL
Nice Sir
Nice Guru
Dada mera ek excel ka problem hai. Ap kya solve kar sakte ho?
Hello sir , kya ye options office 2007 hota h?
Nahi ye 2019 me option hai
Sir agr 10 excel workbook hon or har. Excel workbook ma 15 sheets hain ham sab 10 excel workbook ko kesay combine karain?
It's a brilliant method
Sir, Which excel version you have used to merge multiple files.
Good technique
Bhaijan Multiple select kar k ek var add kar sakte hain ya nahi?
is topic pe meri ek aur vdo h vo dekho, usse 1 click me ho jayega VBA code ki help see
Very useful trick,thank you Sir.
Sir kya ye 3 se zyada files mai possible hai ?
i will try to make a video for bulk files
How it is different from copy and paste? Is it link or relative references
same question....
thank you sirrr. this was a real time saver
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
Sir I'm not understand your question properly
Most helpful Sir thanks
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
does it works with excel 2016
Will it be automatically updated if I enter any new entry in between?
for More then 100 files Shall we use this step or We have any other way ?
Simply copy paste bhi kr skte h wo jyada easy rhega
I use Excel 2013 wherein get data option not found,how can I get it in Excel 2023,plz guide sir...
Can we merge/combine same data format to sum for 12 month
Sir, in which excel version I able to find this function, can you let us know.
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 .
Thankyou apka ❤❤
very good bhai
Sir iske liye ek tool kaise ban sakte hai jisme files folder me ho sirf location do and vo khud hi merger kar le
very very nice sir
Special character problems ko kese solve karte hai. Sir
Thanks, very excellent explanation of the task.
excellent tutorial
Please explain merge different files in to one in Excel 2010 in this version get data tab in not there
appreciate if you could reply
Side me merge ho sakta hai kya???
Excellent
Is this formula work on seclore file???
All excel video good
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
2007 version pe excel marge apne jo dikhaya hai oh korpayenge
Coneection dene mai itna time lag rha hai agr bht sari files ho to aik sath connection kese dengy. Combine to phr hum copy pasty se bhi kr sakty hain
Agar samjh na aaye aur 1 hi sheet me data ho to aap copy krke kisi ek sheet me paste kr le sabse easy 😂