Thank you Dinesh for another great video! My only issue is that this still requires columns to be static.. what do you do if say for example you have a spreadsheet that changes every week i.e. somebody adds a column or removes a column. Will the dictionary function recognise the addition of a new column?
Hello Mr Dinesh. Thanks for the video it was indeed eye opening and informative. Please I am trying to assign a header in sheet 1 to another header in another sheet, so it can copy automatically. For example copying from sheet 1 column with header "name" while the destination column has "full name" as header name, is this possible?
Thank you sir this is quite helpful. I have a question though. How can I modify this VBA to instead of copying entire columns it matches data with dates in the leftmost column of the destination sheet?
These Excel tutorials will guide: www.exceltrainingvideos.com/generate-report-based-on-dates/ www.exceltrainingvideos.com/tag/xlookup/ www.exceltrainingvideos.com/automatically-highlight-column-header/ You can search my website www.exceltrainingvideos.com or this UA-cam channel for more solutions in Excel: goo.gl/5Jx1NP
how to you copy data like that in another copy workbook data to another workbook data? making from Multiple workbook with same data to copy that will submit the data to only one worksheet(database) and collate it and will not replace existing data and just put it below the exsisting data ?
www.exceltrainingvideos.com/how-to-transfer-multiple-rows-of-data-from-multiple-workbooks-into-master-workbook-with-vba/ Please make a copy of the original file and work on it. Once the working of the macro is clear to you, you can work with the original file. You may also like to search www.exceltrainingvideos.com or this UA-cam channel goo.gl/5Jx1NP
Sir ones again thank you so much for this code..I was try this. but I got some error as "An error has occurred: subscript out of range" could you please tell me sir , what I can do for this?
thank you for this video.. but i have a problem i am struggling to solve. i want to copy the columns of same headers from the excel file and while pasting it to another sheet, i want the header also to be copied along with the data.
Thank you! This helped alot. question My first column has "active" and "not active" in them I want to copy only the active members And Instead of deleting the column Can I compare them and only add or delete changes in the list And finally How can I print a copy of the code. I am screen shooting them so I can follow along
These video tutorials will guide: ua-cam.com/video/O21OCZ25d4A/v-deo.html ua-cam.com/video/HgICUiGpy4U/v-deo.html ua-cam.com/video/bfLO1O2NZfw/v-deo.html
Hello Sir, We have a sheet of 56 - 60 columns data information in it. From that sheet I only need 3 column data i.e., Preferred Name, Email Address & Termination Date. The poison of the headers changes each time when we receive the data. So, I want to create a macro based on the "headers" instead of column number to copy data from the existing sheet to the new work book. Could you please help me in this regard.
The following links will help: www.exceltrainingvideos.com/compare-data-lists-using-vlookup-and-isna-functions/ www.exceltrainingvideos.com/highlight-differences-in-2-lists-automatically/ www.exceltrainingvideos.com/compare-2-worksheets-to-create-report/ Or search www.exceltrainingvideos.com
:) many many thanks for this, supper more than expected, Thank you Mr. Takyar , I was trying the collection but ended up not having result. but this video soooo helpful ** Just want to highlight if you can alert who want to copy the provided code they need to change ( If msg Not Equal To "" Then) to (If msg "" Then) to avoid error ** many thanks again :)
You'll have to loop through the multiple worksheets. This VBA tutorial link will guide: www.exceltrainingvideos.com/tag/get-data-from-multiple-worksheets-in-multiple-workbooks-into-master-workbook-with-vba/
Super video.... If we want to consolidate data from different workbooks with some 3 colums to destination workbook.... How can we update this code.... Please sir looking forward to ur reply
This link will help: www.exceltrainingvideos.com/how-to-consolidate-data-from-multiple-workbooks-in-excel/ Or search www.exceltrainingvideos.com or my UA-cam channel goo.gl/5Jx1NP
I have data in sheet one in column A i have item numbers and column B I have item names. I have 1000 rows. Out of these 1000 rows, If an item name example Apple is repeated 15 times, then in sheet 2 i need that apple name and randomly only one item number of that 15apples. If an item name example chocolate is repeated more than 16 and less than 25 times, then I need choclate twice and randomly two item numbers of chocolates. If the item name example computer is more than 25 and less than 35 I need in sheet 2 that computer 3 times and three computer numbers randomly. Please help me with macros on this.
Hi Sir Dinesh, thank you for this wonderful macro, it helped me with my current project at work. I know this was 2 years ago but I hope you get to read this. Also, I want to request if you have made video about a pivot table data with values and making it into a summary of excel and removing the zero values all at once. I wish to have that kind of macro needed for my SAP journal template. So the concept is, automatically pivoting a certain data as a summary and creating a data from that pivot to create a journal entry removing all zeros automatically. Would appreciate your help!! :)
These links will help: ua-cam.com/video/M04rnVoD5mc/v-deo.html ua-cam.com/video/Zt4sqEN-uOU/v-deo.html ua-cam.com/video/NSMqzYtRXyU/v-deo.html ua-cam.com/video/zGRNQIHHu9c/v-deo.html You can also search my channel.
I am getting error "subscript out of range" after copying the code into a module-can you give me a download link of the excel sheet with the code in it".
@@Exceltrainingvideos No, i created your same sheet as source and destination-can you give me the download link of your sample excel with code in it-I am not a VBA code person-just excel.
I want to make a userform from where , I can select the different worksheet from drop down so that all the data entered in userform are entered in selected worksheet. Eg. I want to enter the details in class 7 then Maths then all the details are entered in class 7 maths worksheet and if I select class 7 science then they get entered in class 7 science worksheet. This is to avoide multiple userform. If possible kindly give the code will try . Similarly i want to make question paper so that I select the class and subject and questions are fetched from it for MCQ and how to enter the answer and check it .
Hi, I enjoyed your video as usual. Here is a problem that I am struggling to solve. Say, I have a master file that contains 100 questions for an exam. I want to generate three new sets of questions from the master file. In each of the sets the question numbers shall have to be different from the original sequence. How can I do this using worksheet functions or VBA? Thanks in anticipation.
Selamaleyküm. Hocam mobilya fabrikası için bir takip programı yazmak istiyorum. Neler olacak; makineler arasında veri aktarımı ve veri toplama gibi ben bunu Excel, access, c, c#, hangisi daha uygundur?
Hello Sir, thanks for the lessons on VBA coding it has helped and saved lot of time and improved quality of output. Is it possible to copy that specific column to new workbook and save in field name. For example in the given video excel workbook in the name of city. Please let me the solution sir. Thanks in advance.
Thank you for sharing this macro. My question is how to run this macro on a worksheet that has 1000 columns? Building the dictionary manually is impossible. Keep up the great work.
Sir I m big fan of your... And I want an addition to this.. If sheet1 added more data which will campare to 2nd sheet. If same data present in sheet2. Additional data copy to sheet 2
its very Much important for me to make one file in Excel to make Automatics Quotation, i need to Copy many Colum form one sheet and want to past other sheet.
Great video but sir what if the columns in multiple sheets contain value like inventory how I can do mathematical processes summing and subtracting for instance I have sheet1 contain 4 columns item, brands, types, balance of the first duration and sheet2 contain the same columns except 4 is import and sheet3 contains the same columns except 4 is export here the show result in sheet4 the column4=sheet1+sheet2-sheet3 of course show the rest of columns Sheet4= items,brands,types,balance of the last duration I hope read my comment God bless you
mail id par excel file bhejta hu. apka mail id dijiye na. vendor add karne ke bad vendor code ke combo box mai add kiya vendor show hota hai lekin save karte time pe "venodr code is empty"ye erroe ata hai
sir plz make a video for how to tranasfer data automatically one row to onther workbook master sheet when the row have some data . only data not formula . plz help sir
This link will help: www.exceltrainingvideos.com/get-data-from-multiple-sheets-in-multiple-workbooks-into-master-workbook-with-vba/ Or search www.exceltrainingvideos.com
Hello dinesh sir, My question is Steel sales Table Product|Qty|Wgt|Rate|Unit|Amount SteelTm.10. 350. 49. 1KG. 16660 Pipe Ms.10. 00. 980. Per . 9800 B.Wire . 2. 00. 1024 per. 2048 SS Pipe. 7. 453.350.10KG 158550 Sq Tmt. 1. 100 2500.100KG 2500 In this table how to apply condition for Units, in VBA User form bocz When I put a data in userform then I get units in units I needed ComboBox or check boxes So how to apply UNITS condition in USERFORM. Means when I go to UNITS their will be a options TO Select any One of this. To Multiple with Rate 1.PER 2.10KG 3.1KG 4.100KG When I Select PER It should Multiply with Rate * Qty Ok When I select 10kg/100kg/1kg It should Multiply with Rate * Weight Please show me this Userform Vba code
Great as always!!!!
Thank you!
Thank you very much for your wonderful lessons and for your outstanding style.
Thank you for the feedback.
wow
bahut hi achi jankari
Appreciate your feedback.
thanks sir ji i am big fan of you. i have watched all of your videos
Thank you!
Thank you Dinesh for another great video! My only issue is that this still requires columns to be static.. what do you do if say for example you have a spreadsheet that changes every week i.e. somebody adds a column or removes a column. Will the dictionary function recognise the addition of a new column?
You'll have to redefine the headers locations or use another strategy.
Hello Mr Dinesh. Thanks for the video it was indeed eye opening and informative. Please I am trying to assign a header in sheet 1 to another header in another sheet, so it can copy automatically. For example copying from sheet 1 column with header "name" while the destination column has "full name" as header name, is this possible?
i copied and paste and got this errors " If msg Not Equal To "" Then" IDK what i'm doing wrong?
Copy/Paste doesn't work. You have to check the VBA code line by line even after copy/paste because some characters are changed.
@@Exceltrainingvideos where is the video you spoke of, prior to this one?
@@Exceltrainingvideos what should I put in the "msg" you have it empty? what is it referring to?
Thank you sir this is quite helpful. I have a question though. How can I modify this VBA to instead of copying entire columns it matches data with dates in the leftmost column of the destination sheet?
These Excel tutorials will guide:
www.exceltrainingvideos.com/generate-report-based-on-dates/
www.exceltrainingvideos.com/tag/xlookup/
www.exceltrainingvideos.com/automatically-highlight-column-header/
You can search my website www.exceltrainingvideos.com or this UA-cam channel for more solutions in Excel: goo.gl/5Jx1NP
how to you copy data like that in another copy workbook data to another workbook data?
making from Multiple workbook with same data to copy that will submit the data to only one worksheet(database) and collate it and will not replace existing data and just put it below the exsisting data
?
www.exceltrainingvideos.com/how-to-transfer-multiple-rows-of-data-from-multiple-workbooks-into-master-workbook-with-vba/
Please make a copy of the original file and work on it. Once the working of the macro is clear to you, you can work with the original file.
You may also like to search www.exceltrainingvideos.com or this UA-cam channel goo.gl/5Jx1NP
Thank you so much🙏🙏🙏🙏
Welcome!
Sir ones again thank you so much for this code..I was try this. but I got some error as "An error has occurred: subscript out of range" could you please tell me sir , what I can do for this?
Thank you so much for this amazing code.. it's working .. I fixed the error🙏🙏🙏🙏
thank you for this video.. but i have a problem i am struggling to solve. i want to copy the columns of same headers from the excel file and while pasting it to another sheet, i want the header also to be copied along with the data.
Please search this channel using the keyword 'column'. You'll find at least 6 solutions.
Thank you! This helped alot.
question
My first column has "active" and "not active" in them
I want to copy only the active members
And
Instead of deleting the column
Can I compare them and only add or delete changes in the list
And finally
How can I print a copy of the code. I am screen shooting them so I can follow along
These video tutorials will guide:
ua-cam.com/video/O21OCZ25d4A/v-deo.html
ua-cam.com/video/HgICUiGpy4U/v-deo.html
ua-cam.com/video/bfLO1O2NZfw/v-deo.html
Hello Sir,
We have a sheet of 56 - 60 columns data information in it.
From that sheet I only need 3 column data i.e., Preferred Name, Email Address & Termination Date. The poison of the headers changes each time when we receive the data.
So, I want to create a macro based on the "headers" instead of column number to copy data from the existing sheet to the new work book.
Could you please help me in this regard.
This VBA tutorial will guide: www.exceltrainingvideos.com/copy-multiple-columns-data-from-worksheet-to-worksheet/
Thank You Sir for sharing wonderful video. Can we add dynamically columns in dictionary.
You'll have to use a class module to get multiple data in different columns.
Hi Sir
Please help me out on comparing with multiple or two columns if service date is not falling then out put should show as termed
The following links will help:
www.exceltrainingvideos.com/compare-data-lists-using-vlookup-and-isna-functions/
www.exceltrainingvideos.com/highlight-differences-in-2-lists-automatically/
www.exceltrainingvideos.com/compare-2-worksheets-to-create-report/
Or search www.exceltrainingvideos.com
:) many many thanks for this, supper more than expected, Thank you Mr. Takyar , I was trying the collection but ended up not having result. but this video soooo helpful ** Just want to highlight if you can alert who want to copy the provided code they need to change ( If msg Not Equal To "" Then) to (If msg "" Then) to avoid error ** many thanks again :)
Google doesn't allow angular brackets in the description. Your correction is perfect.
can you give me an excel download link with the code in it
How will I create the same for multiple worksheets. As I have one source sheet but I have to prepare for 3- 4 worksheets
You'll have to loop through the multiple worksheets. This VBA tutorial link will guide: www.exceltrainingvideos.com/tag/get-data-from-multiple-worksheets-in-multiple-workbooks-into-master-workbook-with-vba/
Super video.... If we want to consolidate data from different workbooks with some 3 colums to destination workbook.... How can we update this code.... Please sir looking forward to ur reply
This link will help: www.exceltrainingvideos.com/how-to-consolidate-data-from-multiple-workbooks-in-excel/
Or search www.exceltrainingvideos.com or my UA-cam channel goo.gl/5Jx1NP
It is really good thing for savings a lot of times.
Thankyou
Glad you found it helpful. Please share with your friends.
Sir i need your help if possible please let me know..
I have data in sheet one in column A i have item numbers and column B I have item names. I have 1000 rows.
Out of these 1000 rows, If an item name example Apple is repeated 15 times, then in sheet 2 i need that apple name and randomly only one item number of that 15apples. If an item name example chocolate is repeated more than 16 and less than 25 times, then I need choclate twice and randomly two item numbers of chocolates. If the item name example computer is more than 25 and less than 35 I need in sheet 2 that computer 3 times and three computer numbers randomly.
Please help me with macros on this.
Use loops.
Hi Sir Dinesh, thank you for this wonderful macro, it helped me with my current project at work. I know this was 2 years ago but I hope you get to read this. Also, I want to request if you have made video about a pivot table data with values and making it into a summary of excel and removing the zero values all at once. I wish to have that kind of macro needed for my SAP journal template. So the concept is, automatically pivoting a certain data as a summary and creating a data from that pivot to create a journal entry removing all zeros automatically. Would appreciate your help!! :)
These links will help:
ua-cam.com/video/M04rnVoD5mc/v-deo.html
ua-cam.com/video/Zt4sqEN-uOU/v-deo.html
ua-cam.com/video/NSMqzYtRXyU/v-deo.html
ua-cam.com/video/zGRNQIHHu9c/v-deo.html
You can also search my channel.
I am getting error "subscript out of range" after copying the code into a module-can you give me a download link of the excel sheet with the code in it".
Check your worksheets - do you have the same worksheets with the same names?
@@Exceltrainingvideos No, i created your same sheet as source and destination-can you give me the download link of your sample excel with code in it-I am not a VBA code person-just excel.
I want to make a userform from where , I can select the different worksheet from drop down so that all the data entered in userform are entered in selected worksheet. Eg. I want to enter the details in class 7 then Maths then all the details are entered in class 7 maths worksheet and if I select class 7 science then they get entered in class 7 science worksheet. This is to avoide multiple userform. If possible kindly give the code will try .
Similarly i want to make question paper so that I select the class and subject and questions are fetched from it for MCQ and how to enter the answer and check it .
This link will help: www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/
Sir , while running this macro I am getting an error mesage stating - " An error has occurred : Object required. Please can you help
Check your code carefully. Have you used the angular brackets correctly?
@@Exceltrainingvideos yes now I have fixed it and working fine for me...thank you so much for making such a good video
Hi, I enjoyed your video as usual. Here is a problem that I am struggling to solve. Say, I have a master file that contains 100 questions for an exam. I want to generate three new sets of questions from the master file. In each of the sets the question numbers shall have to be different from the original sequence. How can I do this using worksheet functions or VBA? Thanks in anticipation.
This link will provide a solution: www.exceltrainingvideos.com/generate-test-paper-from-question-bank-using-excel-vba/
I want to copy three columns and paste in destination workbook
Open the workbook and then paste. This VBA tutorial will guide: www.exceltrainingvideos.com/open-workbook-using-vba/
Selamaleyküm. Hocam mobilya fabrikası için bir takip programı yazmak istiyorum. Neler olacak; makineler arasında veri aktarımı ve veri toplama gibi ben bunu Excel, access, c, c#, hangisi daha uygundur?
What are you proficient at?
Getting the following error message: "Subscript out of range". Please help.
Check your code especially the worksheet names.
This is really interesting and wonderful. But, If we I wan't to copy data from one workbook to another.
Is it possible ?
Try by setting paths to the worksheets in the different workbooks.
Hello Sir, thanks for the lessons on VBA coding it has helped and saved lot of time and improved quality of output. Is it possible to copy that specific column to new workbook and save in field name.
For example in the given video excel workbook in the name of city.
Please let me the solution sir.
Thanks in advance.
This VBA lesson will guide: www.exceltrainingvideos.com/how-to-copy-column-data-into-another-workbook/
hi sir this error is coming (user-defined type not defined)
Did you reference the Microsoft Scripting Runtime?
Thank you sir, but if i want to copy up to 5 columns how do i go about it?
This video tutorial will guide: www.exceltrainingvideos.com/get-data-from-multiple-sheets-in-multiple-workbooks-into-master-workbook-with-vba/
Thank you for sharing this macro. My question is how to run this macro on a worksheet that has 1000 columns? Building the dictionary manually is impossible. Keep up the great work.
This video tutorial will guide: ua-cam.com/video/XC5RaEcMWbw/v-deo.html
Hi sir,
I want to copy 3 columns please suggest how to do please please
Replied already.
Sir I m big fan of your... And I want an addition to this.. If sheet1 added more data which will campare to 2nd sheet. If same data present in sheet2. Additional data copy to sheet 2
Try it out!
sir i tried... unable to do the same ... please help
compare the data sheet1 and sheet2 data.
Hi sir help me out
@@omprakasdh1232 did you add the additional data of sheet 1 to the code?
its very Much important for me to make one file in Excel to make Automatics Quotation, i need to Copy many Colum form one sheet and want to past other sheet.
Great video but sir what if the columns in multiple sheets contain value like inventory how I can do mathematical processes summing and subtracting for instance I have sheet1 contain 4 columns item, brands, types, balance of the first duration and sheet2 contain the same columns except 4 is import and sheet3 contains the same columns except 4 is export here the show result in sheet4 the column4=sheet1+sheet2-sheet3 of course show the rest of columns
Sheet4= items,brands,types,balance of the last duration
I hope read my comment
God bless you
This link will help: www.exceltrainingvideos.com/inventory-management-using-tables-in-excel/
Save karte time pe " combo box is empty "he message ata he.lekin combobox me data show hota he.
Please help
Can you share your code here?
mail id par excel file bhejta hu.
apka mail id dijiye na.
vendor add karne ke bad vendor code ke combo box mai add kiya vendor show hota hai lekin save karte time pe "venodr code is empty"ye erroe ata hai
@@Exceltrainingvideos ?
sir plz make a video for how to tranasfer data automatically one row to onther workbook master sheet when the row have some data . only data not formula . plz help sir
This link will help: www.exceltrainingvideos.com/get-data-from-multiple-sheets-in-multiple-workbooks-into-master-workbook-with-vba/
Or search www.exceltrainingvideos.com
thanks sir
Welcome! Please share with your friends too.
Hello dinesh sir, My question is
Steel sales Table
Product|Qty|Wgt|Rate|Unit|Amount
SteelTm.10. 350. 49. 1KG. 16660
Pipe Ms.10. 00. 980. Per . 9800
B.Wire . 2. 00. 1024 per. 2048
SS Pipe. 7. 453.350.10KG 158550
Sq Tmt. 1. 100 2500.100KG 2500
In this table how to apply condition for Units, in VBA User form bocz When I put a data in userform then I get units in units I needed ComboBox or check boxes So how to apply UNITS condition in USERFORM.
Means when I go to UNITS their will be a options TO Select any One of this.
To Multiple with Rate
1.PER
2.10KG
3.1KG
4.100KG
When I Select PER
It should Multiply with Rate * Qty Ok
When I select 10kg/100kg/1kg
It should Multiply with Rate * Weight
Please show me this Userform Vba code
If ComboBox1="PER" then
do the following
end if
@@Exceltrainingvideos
Thank you for once again previous time I asked you how to use Len function I got it .
@@Exceltrainingvideos
Sorry I m not getting this time will you send me a sample of vba code for this please