Excel Macros & VBA - Tutorial for Beginners - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Genet
Hi Kevin, I saw your video, It is very helpful for me. There is some issue I can not solve yet. I made students' result. This is how I used to print. I used students' ID. to search. When I insert -1- (without quotation) in cell the specific student's result with subjects will displayed. Then I printed it. When I insert on the same cell -2-, the next student's record will displayed, and ... I printed it out. Then -3-, print, -4- print, -5-,....... up to 60 or 80. I cant specify the range like -1-15- by using user input box. I used macro, but I cant limit the range.
Here is my sample code if it is gives you hint:
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -1--
Range(-J6-).Select-
ActiveWindow.SelectedSheets.PrintOut Copies:=1-
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -2--
Range(-J6-).Select-
ActiveWindow.SelectedSheets.PrintOut Copies:=1-
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -3--
Range(-J6-).Select-
ActiveWindow.SelectedSheets.PrintOut Copies:=1-
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -4--
Range(-J6-).Select-
ActiveWindow.SelectedSheets.PrintOut Copies:=1-
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -5-
end sub
Thanks, Kevin.
reply
Hi Kevin, I saw your video, It is very helpful for me. There is some issue I can not solve yet. I made students' result. This is how I used to print. I used students' ID. to search. When I insert -1- (without quotation) in cell the specific student's result with subjects will displayed. Then I printed it. When I insert on the same cell -2-, the next student's record will displayed, and ... I printed it out. Then -3-, print, -4- print, -5-,....... up to 60 or 80. I cant specify the range like -1-15- by using user input box. I used macro, but I cant limit the range.
Here is my sample code if it is gives you hint:
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -1--
Range(-J6-).Select-
ActiveWindow.SelectedSheets.PrintOut Copies:=1-
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -2--
Range(-J6-).Select-
ActiveWindow.SelectedSheets.PrintOut Copies:=1-
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -3--
Range(-J6-).Select-
ActiveWindow.SelectedSheets.PrintOut Copies:=1-
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -4--
Range(-J6-).Select-
ActiveWindow.SelectedSheets.PrintOut Copies:=1-
Range(-J5-).Select-
ActiveCell.FormulaR1C1 = -5-
end sub
Thanks, Kevin.
reply
Full
Hello Kevin, I have a question and in much need of help. I just recently took a job as a compliance analyst and need recommendations or ideas on how to approach this problem. So we get data from a website and enter into multiple sheets for record keep and for weekly analysis. My problem is the way one excel sheet was set up. On this 1 sheet we have tabs starting 1-100+ each tab has many tables with multiple test dates along with bacterial ranges. When test has been completed at a specific site we also enter the end date. This company is starting to grow and data just keeps growing. I-m trying to keep it user friendly so I-m trying to stay away from true databases. But i want to have relationship between sheets.
reply
Hello Kevin, I have a question and in much need of help. I just recently took a job as a compliance analyst and need recommendations or ideas on how to approach this problem. So we get data from a website and enter into multiple sheets for record keep and for weekly analysis. My problem is the way one excel sheet was set up. On this 1 sheet we have tabs starting 1-100+ each tab has many tables with multiple test dates along with bacterial ranges. When test has been completed at a specific site we also enter the end date. This company is starting to grow and data just keeps growing. I-m trying to keep it user friendly so I-m trying to stay away from true databases. But i want to have relationship between sheets.
reply
Ken
Excellent videos Kevin...I download csv files that has numbers like this: 1,915,259.2500. There are 100's of rows of these numbers that are time stamped and I need to get the difference between the times. This means I have to remove the - , and the . - before this can happen, which as you can imagine, takes absolute ages.
Looking at the macro video, it appears that it would be possible to automate this. Is this assumption correct? Have you already done a video on this?
Thanking you so much in advance... :)
reply
Excellent videos Kevin...I download csv files that has numbers like this: 1,915,259.2500. There are 100's of rows of these numbers that are time stamped and I need to get the difference between the times. This means I have to remove the - , and the . - before this can happen, which as you can imagine, takes absolute ages.
Looking at the macro video, it appears that it would be possible to automate this. Is this assumption correct? Have you already done a video on this?
Thanking you so much in advance... :)
reply
Trenton
If you're spending time learning right now, idk why anyone would pick vba, a language Microsoft has said for years it will no longer develop new features for. Learn something modern. IMO Microsoft will never end support for it (as long as they allow it in their office suite) but the time is coming when their office 365 suite will allow code behind similar to that of Google docs. A much much better alternative for learning something new right now. This is tech from like 2005
reply
If you're spending time learning right now, idk why anyone would pick vba, a language Microsoft has said for years it will no longer develop new features for. Learn something modern. IMO Microsoft will never end support for it (as long as they allow it in their office suite) but the time is coming when their office 365 suite will allow code behind similar to that of Google docs. A much much better alternative for learning something new right now. This is tech from like 2005
reply
Rajesh
Hi Kevin, Thank you for the video. I have made macros using Record Macro. But its not working on new data. I have 5 lakhs rows data and everyday it new data will be added to it. I run macro in this sheet by bringing information using Vlookup from other 6 excel workbooks and changing some modifications. when new data adds in, its taking only whatever the data present while recording macro. Any solution to work this macro on new data that daily adds in.
reply
Hi Kevin, Thank you for the video. I have made macros using Record Macro. But its not working on new data. I have 5 lakhs rows data and everyday it new data will be added to it. I run macro in this sheet by bringing information using Vlookup from other 6 excel workbooks and changing some modifications. when new data adds in, its taking only whatever the data present while recording macro. Any solution to work this macro on new data that daily adds in.
reply
Word
Cannot begin to express how impressed I am . I was given someone's spreadsheets to update and one of course was misaligned as stacked data. I was forced to cut and paste incoming additions in the stacked data (sadly not cookies)and spent hours until now. Bam.... I can do this in no time - meaning more coffee breaks for me, smiles from the boss and I wish I could send Kevin one of his choice (coffee not boss needless to say)
reply
Cannot begin to express how impressed I am . I was given someone's spreadsheets to update and one of course was misaligned as stacked data. I was forced to cut and paste incoming additions in the stacked data (sadly not cookies)and spent hours until now. Bam.... I can do this in no time - meaning more coffee breaks for me, smiles from the boss and I wish I could send Kevin one of his choice (coffee not boss needless to say)
reply
muhammad
Hi, I need your help please. -
I have 1000 employees data in excel file (1000 rows). I want to move these data into pdf files with a single click. I required 10 rows data in each single pdf file. There are approximately 1000 rows data, so 100 pdf file will automatically generate with single click. The name of pdf files will automatically create in serial like 1,2,3,4,...100.
reply
Hi, I need your help please. -
I have 1000 employees data in excel file (1000 rows). I want to move these data into pdf files with a single click. I required 10 rows data in each single pdf file. There are approximately 1000 rows data, so 100 pdf file will automatically generate with single click. The name of pdf files will automatically create in serial like 1,2,3,4,...100.
reply
Clarity
I need to replace certain dates on every workbook I receive. recorded a macro but everytime I apply it to another workbook I get an error and I have to do the task by hand or create a macro for that specific worksheet that I will not open ever again. Is there a way to run this macro to every new worksheet instead of repeating this task manually every time?
reply
I need to replace certain dates on every workbook I receive. recorded a macro but everytime I apply it to another workbook I get an error and I have to do the task by hand or create a macro for that specific worksheet that I will not open ever again. Is there a way to run this macro to every new worksheet instead of repeating this task manually every time?
reply
Shirley
Hi Kevin, I am looking for the code to
Compare the range of dates (mmm-yy format) in column A8:A25 to a -start date- in cell D2. If the date in column A is = -start date-, then copy all the values in cells B8:B25 to the 4th column right of column A starting from the row the date is = -start date-. Appreciate your advice!
reply
Hi Kevin, I am looking for the code to
Compare the range of dates (mmm-yy format) in column A8:A25 to a -start date- in cell D2. If the date in column A is = -start date-, then copy all the values in cells B8:B25 to the 4th column right of column A starting from the row the date is = -start date-. Appreciate your advice!
reply
Hank
Hello, Kevin. I've watched many videos promising to -teach- macros and VBA, and I have to say that yours are some of the very best! Do you have any courses planned where you offer a deeper dive into VBA? I'd be happy to sign up for a full course if you were to offer any!! Thank you, and I hope to see more
reply
Hello, Kevin. I've watched many videos promising to -teach- macros and VBA, and I have to say that yours are some of the very best! Do you have any courses planned where you offer a deeper dive into VBA? I'd be happy to sign up for a full course if you were to offer any!! Thank you, and I hope to see more
reply
Add a review, comment
Other channel videos
