sir can you tell me how we can move figure from one cell to another using if function like if we have 4, catagory , coloumn outstanding , paid ,and overdue, if i select from drop down list in cataogy Aamount will shift to coloum A and If i select B it will shift to B and remove from outstanding
Sir different sheets sy agar koi report generat Karen wo bhi pdf file us ki only PDF coding baten kiyo k us report mein lastrow hrdafa change hota hai Kisi Ka data bara ha Kisi Ka chota to ya automatically kaisy Karen please respond...🙏🙏🙏
Hi sir I used your number vba coding for consolidating the files and it is working fine but can you please help me to provide the coding with paste special values in the coding?
Hello Sir, Would you please tell me how to avoid the multiple header fields in the merged file? I just want to keep the header fields just one time and delete all other header fields
Ha sir 1qution he Agar Excel me 5 sheer he or un sabhi sheeto me bhi andar 5 - 5 sheet he Jo paheli sheet he No 1 ke andar 1sheet No 2 ke andar 1sheet No 3 ke andar 1 sheet No 4 ke andar 1 sheet No 5 ke andar 1sheet Ye Jo pise wali sheet ka data agar same row or same colum Me same cell me ho to new main sheet Me kese meger kar sir
I think seven of my excel sheet with one sheet by hyperlink, but when I changed the folder, the hyperlink file does not work. what is the solution and can I solve it with macro?
This looks good. Thanks for this informative video.. I have 13 different (master logs) excel files for 13 different projects. Each of the project files have many different tabs in it with different formats. I want to create a Super Log containing all these data where selected outputs could be taken as and when needed..
Sir plz batana ek items ko alag alag department ya section me issue kaise kare sir Excel pe ya uska baad me bi Recive & issue karneka process batana plz batana ya video banana plz.....
Hi what if i have to merged particular number of line items from different sheet like if i have 100 sheets with 100k line item in each sheet but i want to make a different single merged sheet of 100k by picking 1000 line items from each
Thanks for this. Can you help me with my requirement I have multiple Tabs with huge data (each tab has more than 8 lakh entries), I can't combine all into single Tab, as it exceeds row limit If there are 100 records on single person, those needs to be report as 1 but value (over time hours), should sum
Thanks sir . Sir if want to merge sheet that have 2 different candidate like (a and b) in one column and rest all column r same like fd , rate . And common colums policy date and amount ,so we want to merge both A & B data side by side .AND COMPARE SAME AMOUNT AND DATE PERFORMANCE IN ONE LINE like left side A data and right side B DATA. Sir I have done this tast through > get data source- multiple table-mearge tables with common column but in this process 1st extract A B data in 2 diff. Table AND THEN MEARGE BOTH DATA WITH HELP OF 2 COMMON COLUMN DATE AND POLICY NAME SIR IF VBA CODE SOLUTION AVALABLE FOR AUTO MEARGE AND REFRESH DATA FROM TABLE
in 4th code, if my workbook has multiple sheets, and some files are in hide , now i want merge only the sheet3 from all the files in folder . for every file i am getting the system promt of "update-- dont update- cancel" and other thing is how to ignore the header rows which repeating multiple times.
Hello Sir im trying to merge 19 files by using ur 4th macro function but error occurring no files. i have changed the drive path still error isshowing. please help me with this
In 4th code What I basically want is to merge multiple excel files into one workbook. I only want to keep the header row from the first excel file and ignore header row of the remaining excel files (as they are all the same). So the end result should be the Header + data from the first excel file and from the remaining excel file I only need the data rows, not the first row which has column heading similar to the first file. The below copy paste all the rows and columns from all the excel files .can you help me out in this
If i have 30 Excel file and each file has 4 Tab. But i want to pull only specific Tab from all this 30 into 1 Note: Specific file format will he same for all. How we can do this ? Waiting for your reply..
This is basic data merge with same format, same column into one file. I want to merge different files data with their different values in different cells and bring to one file. Can you help in this pls. Thanks
Sir your video is appreciate, I have multiple excel invoice files in excel in which i have Client Name in A Column 13 Row. invoice No in H Column and 3 Row, Invoice date in J Column and 3 Row, Net Taxable Amount in K column and 33 Row, Tax Amount in K column and 34 and 35 Row, Gross Amount in K column and 39 Row. So i want to Pull all this value in other excel file. Can you provide excel vba code for this. For your kind information all files are in same format. Thanks 🙏🙏
Meri ek sheet mai ek cell mai time 00:00 hai (like A1 00:00) aur dusara cell mai time 01:00 hai (like A5 01:00), muje ish dono cell ke bich mai jo time fillers hai vo bharni hai. Aur different time duration ki file alag sheet mai hai. Vo time leke muje in dono cell A1 aur A5 ke bich mai approx 1 hours time set ho jay.. vo sir kaise kare can you help.
Sir, maan lijiye hum 5-7 workbooks merge ik sheet mein kare to agar hum kisi workbook mein change kare to automatically main sheet per change hoga ke nahi
Sir How to merge Gstr2a Data full Year ka ish data me toh ye koi bhi kaam nahi karenge please Make a Video to merge Gstr2a Data full Year with same Formating
Please this data into separate row Like sfdgdgdag15,sfsafsffsf16,sfsafsffsf17,sfsafsffsf18,sfsafsffsf19 sfdgdgdag15 sfdgdgdag16 sfdgdgdag17 sfdgdgdag18 sfdgdgdag19 Column 3000
Code Link 👉 techguruplus.com/combine-merge-excel-files-data-in-one-vba-code/
Buy Excel & Word Course 👉 TechGuruPlus.com
Download All Projects 👉 techguruplus.com/excel-project-practice-files-download/
Please share details for this course I want to purchase
Ok plz call me on 9536 250020
website: www.techguruplus.com/excel-course
Please make a video on Merging / Consolidating All GSTR 2B in the folder with All sheets in each GSTR 2B.
Thanks.
Excellent
Thank you so much. 30 NO'S EXCEL FILE MERGED IN ONE EXCEL SHEET IN 1 MIN.
Great Sir
very helpful
Sir While searching something in for xls i got your Channel Hats of you sir and your work!!!!
thank you sir
Thank you sir it's very helpful and not only this but also at all videos.
Very nice
Good video
Thank You Sir, Very helpful
Lot of Thanks... Genius Method
Very nice 👍👍
It's very helpful video ,VERY EASY METHODE, THANK YOU
Welcome
Excellent 👍👍
y bhut acha h sir thanx
Very nice sir
Amazing Nazim sir
Thank you so much bhai it's working ❤
Thank you very much sir. Very useful vba codes.
Very good video thank you sir,❤
sir can you tell me how we can move figure from one cell to another using if function like if we have 4, catagory , coloumn outstanding , paid ,and overdue, if i select from drop down list in cataogy Aamount will shift to coloum A and If i select B it will shift to B and remove from outstanding
Thank you so much sir for helping me 😊
Sir different sheets sy agar koi report generat Karen wo bhi pdf file us ki only PDF coding baten kiyo k us report mein lastrow hrdafa change hota hai Kisi Ka data bara ha Kisi Ka chota to ya automatically kaisy Karen please respond...🙏🙏🙏
Hi sir
I used your number vba coding for consolidating the files and it is working fine but can you please help me to provide the coding with paste special values in the coding?
Sir, your courses are great. I liked your informative video, thank you Sir
Sir code se vlookup lgaa ke apne according data kese bnaye 2 alg format data se
This is All Employees of Reliance.😂😊
sir g pdf to excel data convert ki koi video b bna dain
sir ek sheet m bna hua data b filter ho k alg alg sheet m aa jaye esa option b laye pleas
Sir please make vba code for GSTR2A Data of all months import and merge and create pivot using vba
Hi, Your video is very useful . Pl suggest method for combining multiple sheets by its names from different excel workbooks .
Very informative... helped me a lott❤
Hello Sir,
Would you please tell me how to avoid the multiple header fields in the merged file? I just want to keep the header fields just one time and delete all other header fields
🎉thanks bro
Thank you very much 👍🙏🏼
JAzakAllah Nazim bhai, insha Allah apsey baat karta hoon.
I have multiple sheet with type such as .xslx & .csv so can we add in vba code , pls guide me
sir, i have multiple vba dinamic files and i want this file one workbook also this files should open using press button to open required vba file
Very good sir....if possible please provided solution for merging of sheets containing blank rows
Very good sir 🎉🎉🎉🎉
Wlcm Sir
Parts enventory ke liye video bnaiye
Rojmel or khatabook kaise banana or uski print kese karani vo shikhae
Zabardast
Agar old sheet me kuch add ya change kar te hai to kya marj sheet me change ho ga kya
nahi automatically update nahi hoga
I want to color cell while moving cursor please guide me in simply way
Sir, Thanks a lot for multiple files in one file with VBA code.I am so excited but its not work?
Ha sir 1qution he
Agar Excel me
5 sheer he or un sabhi sheeto me bhi andar 5 - 5 sheet he
Jo paheli sheet he
No 1 ke andar 1sheet
No 2 ke andar 1sheet
No 3 ke andar 1 sheet
No 4 ke andar 1 sheet
No 5 ke andar 1sheet
Ye Jo pise wali sheet ka data agar same row or same colum
Me same cell me ho to new main sheet
Me kese meger kar sir
I think seven of my excel sheet with one sheet by hyperlink, but when I changed the folder, the hyperlink file does not work. what is the solution and can I solve it with macro?
This looks good. Thanks for this informative video.. I have 13 different (master logs) excel files for 13 different projects. Each of the project files have many different tabs in it with different formats. I want to create a Super Log containing all these data where selected outputs could be taken as and when needed..
Sir excel mein bank template kaise laye ?
Can you please help me
Different sheets different columns sum in one sheet
😢
Maine alag sources csv file download kia hai sab merge karna hai ek sheet me
bhut usefull hai bus ye ab new excel pr video banaye pythone ka use karke
Sir plz batana ek items ko alag alag department ya section me issue kaise kare sir Excel pe ya uska baad me bi Recive & issue karneka process batana plz batana ya video banana plz.....
Can we perform if the headers are different on all the sheets, few headers wiil be same. What you suggest
Hi what if i have to merged particular number of line items from different sheet like if i have 100 sheets with 100k line item in each sheet but i want to make a different single merged sheet of 100k by picking 1000 line items from each
Thanks for this.
Can you help me with my requirement
I have multiple Tabs with huge data (each tab has more than 8 lakh entries), I can't combine all into single Tab, as it exceeds row limit
If there are 100 records on single person, those needs to be report as 1 but value (over time hours), should sum
How we can merged sales trend of multiple sheets into one sheet of different outlets
Thanks sir . Sir if want to merge sheet that have 2 different candidate like (a and b) in one column and rest all column r same like fd , rate . And common colums policy date and amount ,so we want to merge both A & B data side by side .AND COMPARE SAME AMOUNT AND DATE PERFORMANCE IN ONE LINE like left side A data and right side B DATA. Sir I have done this tast through > get data source- multiple table-mearge tables with common column but in this process 1st extract A B data in 2 diff. Table AND THEN MEARGE BOTH DATA WITH HELP OF 2 COMMON COLUMN DATE AND POLICY NAME SIR IF VBA CODE SOLUTION AVALABLE FOR AUTO MEARGE AND REFRESH DATA FROM TABLE
Sir in code 3 where we giving folder path I want my data to merge in a single sheet without picking headers
what if there are multiple sheets in one all excel file and data is there. in that case how to achieve task.
thanks for Knowledge sharing ... i have problem 4th number code . when run code then on file messages in excel. when what i do
show me on Whatsapp 9536250020
hi sir make your website is not open to download code
in 4th code, if my workbook has multiple sheets, and some files are in hide , now i want merge only the sheet3 from all the files in folder . for every file i am getting the system promt of "update-- dont update- cancel" and other thing is how to ignore the header rows which repeating multiple times.
❤
2nd formula not work properly error1004
hi sir 3 different bank ka excel data 1 hi excel may kese merge kare day by day ?
thank you
Sir 5 way to merge vba code ko download ka vikalp de dijiye aise bar bar copy past karna pad raha hai
I am facing issue in merge the excel files
if your files to be merged are in ".xls" format then... change Filename = Dir(filefolder & "*.xls") in 4 th code and check result.
Sir mene code 5 use Kiya hai lekin merged sheet banti hai per vo blank aati hai.
How to merge similar information from multiple excel table of multiple file in one table?
Hello Sir im trying to merge 19 files by using ur 4th macro function but error occurring no files. i have changed the drive path still error isshowing. please help me with this
Ok kindly try 5th code it will work
But this would also be possible with power query instead of this long way
Sir अगर एक xl file मे १ से जादा file हो तो कैसे करे
Please share sample files also .
In 4th code What I basically want is to merge multiple excel files into one workbook. I only want to keep the header row from the first excel file and ignore header row of the remaining excel files (as they are all the same). So the end result should be the Header + data from the first excel file and from the remaining excel file I only need the data rows, not the first row which has column heading similar to the first file. The below copy paste all the rows and columns from all the excel files .can you help me out in this
If i have 30 Excel file and each file has 4 Tab. But i want to pull only specific Tab from all this 30 into 1
Note: Specific file format will he same for all.
How we can do this ?
Waiting for your reply..
Sir, iss file ko macro workbook format me save karna hoga kya ?
Sir mujhe isme sheet name ka bhi coloum chahiye.. plz reply
Sir code 4 me folder part automate ho jyada badiya rhega please wo kaise krna hai
Guruji ...Namaskar...In my GSTR2A files of 12 Nos. in each file there will be difference sheets...how to merge the same sheet in one sheet
Namaste brother, try this vba code to merge
This is basic data merge with same format, same column into one file.
I want to merge different files data with their different values in different cells and bring to one file.
Can you help in this pls.
Thanks
yes this code will work plz try on your data
@@business-excel my sheet cell locations are different i.e
D6-D10
F16
F42
Actually I've multiple invoices and i want to pick each invoice data as per given cell number and merge in one table in a separate workbook
Larg data Excel file bhoot hang hote hai open karte wkt what we need to du
No file error aa raha hai
Sir If my files are in C drive then how to do it by code 1
Web per koe source code nhe
Sir your video is appreciate, I have multiple excel invoice files in excel in which i have Client Name in A Column 13 Row. invoice No in H Column and 3 Row, Invoice date in J Column and 3 Row, Net Taxable Amount in K column and 33 Row, Tax Amount in K column and 34 and 35 Row, Gross Amount in K column and 39 Row. So i want to Pull all this value in other excel file. Can you provide excel vba code for this.
For your kind information all files are in same format.
Thanks 🙏🙏
how to merge multiple excels with multiple sheets into one sheet,plz help me
Is there any way that we can name multiple folder in single click?
Meri ek sheet mai ek cell mai time 00:00 hai (like A1 00:00) aur dusara cell mai time 01:00 hai (like A5 01:00), muje ish dono cell ke bich mai jo time fillers hai vo bharni hai. Aur different time duration ki file alag sheet mai hai. Vo time leke muje in dono cell A1 aur A5 ke bich mai approx 1 hours time set ho jay.. vo sir kaise kare can you help.
Getting error
No files
Sir, maan lijiye hum 5-7 workbooks merge ik sheet mein kare to agar hum kisi workbook mein change kare to automatically main sheet per change hoga ke nahi
Auto change nahi hoga dobara merge krna padega
HOW DATA FILTER WORK IN EXCEL ABOVE 10000 ROW?,
Sir ya code excel 2013 mei work karaga kiya?
How to consolidate multipul sheets with multiple data
Sir How to merge Gstr2a Data full Year ka ish data me toh ye koi bhi kaam nahi karenge please Make a Video to merge Gstr2a Data full Year with same Formating
Please this data into separate row Like
sfdgdgdag15,sfsafsffsf16,sfsafsffsf17,sfsafsffsf18,sfsafsffsf19
sfdgdgdag15
sfdgdgdag16
sfdgdgdag17
sfdgdgdag18
sfdgdgdag19 Column 3000
Sir
FolderPath change krne ke liye aap ne bataya nhi
File ki location PATH change krne ke bad me VBA code work kr rha h.