Hi Mike. This is part 1 of my message... I use Excel 70% of my day, every day. Today I was recording a macro, (to run in various open workbooks) that I never would have done before this video. I tried recording macros before but always battled because of not really understanding things like the 'relative' button. I'm a visual learner and I've got it now. You add to my enjoyment and understanding of my work...part 2 to follow
I wanted to produce a monthly invoice and an expenses sheet from my daily training job entries and so wanted everything to be entered automatically. Now - using your macros - this is so much easier and quicker than it used to be. I think the idea I had (above) saves having to add the first entry manually and makes this even more automatic now, but thanks. Paul
part 2....So macros aren't your thing; you still helped me. Through your videos, especially the Highline playlist, you have given me incredible insights. You will never know how much you have helped me. Thank you
Just a big thank you! I've learn so much with your youtube videos! I started knowing only mathematical equation and now I just finished a big database for my music school that is working automaticly for data entry, referal, reports, billing, payment tracking and so much more! Without your help I would not be in position to build my business alone! So, big thank you again!!!
I am impressed that your ok with saying "someone like me that doesn't know how to write code".Thank you Mr Garvin for all your videos, ive learned alot from you. GO SPURS!!!
Thank you so much for your informational videos. I find them very helpful for when I'm stuck on a certain task I would like to do and just can't figure out how to do it. Most of the time you have a video that relates to what i'm doing. Keep up all your hard work and thanks again!
Whole Number usually means 1, 2, 3... Integers usually means ...-2, -1, 0, 1, 2... To see if G7 equals an integer (no decimals), try: =G7=INT(G7) This will deliver TRUE if there are no decimals. You could also use something like: =IF(G7=INT(G7),"Integer","Not Integer")
I do not have many VBA videos, becasue I am not good with VBA. Bill Mr Excel Jelen has a great video series for sale (search Amazon). Also, RUclips has many VBA videos, but I can not suggest one that is better than the other.
Dear Mike Girvin, That is a very useful video, i am so tuned to your teaching without which i cannot image VBA, i request you to make more video on VBA. anand varma
Your the man! Exactly what I needed! I couldn't figure out how to get my data to start in a new row. This was perfect, Thank you for putting your time into this!
you probably dont care but does any of you know a trick to log back into an instagram account..? I stupidly lost my password. I love any tips you can offer me!
Thank you Mr. Garvin for put a video about Macro, it was very nice, for give simple idea about it !!! Do you have other videos specifically for Financial Analyst ? I am learn about dashboard right now !!!
Great video and very helpful instead of having to learn the code. It took a couple of times of making mistakes and redoing the macro, but got it to work perfectly!!
ExcelIsFun Do you have a video on how to get data that meets a criterion to appear in another worksheet? I've found other videos that demonstrate using the Advanced Filter option, but I cannot get that to work (get an error), and not sure if that is the best solution. So as an example, I have data regarding providing project quotes and each have a status code. I want to use the status code to break up the projects into different worksheets, so that a person doesn't have to go through the entire data table or use various column filters (keeping the individuals from needing to access the data table to maintain data integrity). :)
For advanced filter, maybe: Highline Excel 2013 Class Video 37: Excel Advanced Filter Extract Data 26 Examples Basic - Advanced for formulas, maybe: Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through
Would it not be a simple "work-around" to have this work, when there are no existing entries, to CLICK the LAST CELL at the bottom of COLUMN A and then ARROW UP to "Jump to the top"? Just started learning Excel last week, thanks for all of these great videos. You're an excellent instructor.
Hello. Congratulation first of all for your videos and thank you very much. I have learned a lot from your videos which made my life way easier in my daily work. I wanted to ask you if do you have any video for VBA tutorials or do you plan to put on RUclips such videos in the near future? Otherwise may you recommend to me any place where to start learning VBA? Thanks and GOD bless you.
Just found this range of videos - they are truly brilliant - thanks for all the work! I just have one question, can you point me to a video where i can filter rows of information into different (defined tabs) once a cell fits a specific criteria. (the information in the cell will dictate what tab the entry goes. hope im making myself clear, thanks in advance
I struggled to make this work too. I then tried adding a title above the table headers and this did the job. (It could possibly be a hidden row or use white text on white?)
This i very useful! Just what I have been looking for for the automated audit sheet that I have been trying to create for my employees' Image and Uniform Audit. Thanks a lot
Great video! I wonder if u also have a tutorial explaining how to create a matro which would to move data to a specific category (the number of them will be limited from the drop-down list) in the table. Thanks for any suggestions in advance!
This really what I need thank you very much! can I ask if you know or could you make a video that allow you to edit all the entries you've been created with this video without going to the table? just like what you did but now instead of new entry the cells c5 and c6 or even c4 can be change via macro?
You are amazing thank you for your video, i have a question how to do copy paste to another worksheet using macro like you explain here but for filtered data please ?? I always get a incomplete rows after run the macros, appreciate if you can tell me how to do this 🙏thank you.
Mariam Dear... Ctrl+Down arrow Key for "Jump to Last value in Row", Or You Should "Jump to Last Row", Same as it... Ctrl+Down Up Key for "Jump to First value in Row", Or You Should "Jump to first Row", You Also Apply key right key and left arrow key I hope you will understand ;)
Hello, Thanks very much for the video. I am following and learning a lot. Currently I am trying to create a macro which follows the same procedure as video. Problem I am facing is "It is not pasting the first value and everytime overriding". Please advice.
Thank you for educating me on the data entry process, it was really helpful. Can you help me with how do i modify the code to apply this macros on a protected sheet. In other words - i wish to run the similar macros in a protected sheet as i do not users to be able to edit the contents of the table.
Mr excel, one observation - the macro works provided we have added 1st record on the table; Should there be no records to start with, then the last row cell gets selected?
Since I do not actually know how to write the VBA code (instead of getting the Marco Recorder to do it for you), I do not know how to do that. It is easy though, if you can write VBA code. This is a great alternative site (not affiliated with excelisfun at RUclips) where you can ask Excel VBA questions: mrexcel [dot] com/forum
Sorry, I had one other question. There's a place in the video around 5:55 where you need to use ctrl-down arrow to make sure it selects the next empty cell to add to. But if I use that when there is no data yet, it brings it to the last cell in the worksheet rather than the next cell with no data (with or without transition keys). So that shortcut seems to work if you have data in the table already, but not if you're trying to add the first item in the table.
It sounds like you may need hand written VBA code to solve your two problems. I do not know how to do that. You might want to try the alternative site (THE best Excel question site): mrexcel.com/forum
+ExcelIsFun Hey! Ashay To The Rescue Use Cells (Rows.Count, "A").End (xlUp).Select It Will Work No Matter How Many Rows Of Data (Even 0!) In The Cell Object "A" Represents Column A
this is great and very helpful, would it be possible to create a macro on the same first sheet to find and remove the data from your table by just putting in say the ID, and it wipes all the information from that row for that id. thank
9 Years After and still this is super super helpful. This saved me a ton of time on the web searching for a perfect solution. Amazing, and Thank You!
Hi Mike. This is part 1 of my message... I use Excel 70% of my day, every day. Today I was recording a macro, (to run in various open workbooks) that I never would have done before this video. I tried recording macros before but always battled because of not really understanding things like the 'relative' button. I'm a visual learner and I've got it now. You add to my enjoyment and understanding of my work...part 2 to follow
This was super helpful. The way you explained was way better than the other sources we searched for the last couple of hours!
I wanted to produce a monthly invoice and an expenses sheet from my daily training job entries and so wanted everything to be entered automatically. Now - using your macros - this is so much easier and quicker than it used to be. I think the idea I had (above) saves having to add the first entry manually and makes this even more automatic now, but thanks. Paul
You are one of the best Tutors I have ever seen.
Thanks : )
Gotta tell the truth: I am not a big code writer...
You are welcome for all the videos!
Go Boston!!!
part 2....So macros aren't your thing; you still helped me. Through your videos, especially the Highline playlist, you have given me incredible insights. You will never know how much you have helped me. Thank you
Just a big thank you!
I've learn so much with your youtube videos! I started knowing only mathematical equation and now I just finished a big database for my music school that is working automaticly for data entry, referal, reports, billing, payment tracking and so much more! Without your help I would not be in position to build my business alone! So, big thank you again!!!
You are welcome! I am glad that the videos help!
Thank you Mr. Garvin. I am a new financial controller - I know it will certainly impress my bosses in the upcoming few projects. Thanks alot.....
I am impressed that your ok with saying "someone like me that doesn't know how to write code".Thank you Mr Garvin for all your videos, ive learned alot from you.
GO SPURS!!!
Thank you so much for your informational videos. I find them very helpful for when I'm stuck on a certain task I would like to do and just can't figure out how to do it. Most of the time you have a video that relates to what i'm doing. Keep up all your hard work and thanks again!
This is a great video on macros and looking at form controls to move records to a table.
I LIKE YOU SO MUCH!!! FOR LESSONS LIKE THESE!!! GOD BLESS YOU FOR YOUR JOB! THANK YOU SO MUCH FROM KAZAKHSTAN.
Whole Number usually means 1, 2, 3...
Integers usually means ...-2, -1, 0, 1, 2...
To see if G7 equals an integer (no decimals), try:
=G7=INT(G7)
This will deliver TRUE if there are no decimals.
You could also use something like:
=IF(G7=INT(G7),"Integer","Not Integer")
I do not have many VBA videos, becasue I am not good with VBA. Bill Mr Excel Jelen has a great video series for sale (search Amazon). Also, RUclips has many VBA videos, but I can not suggest one that is better than the other.
Cool! If your idea works, then awesome! I am glad that the video helped!
Dear Mike Girvin,
That is a very useful video, i am so tuned to your teaching without which i cannot image VBA,
i request you to make more video on VBA.
anand varma
Finally you have to migrate from formulas to VBA. Nice video First time I saw the use of button underneath the record macro button.
Thanks! I am glad that it is a useful video!
Absoultly it is nothing but a essence what I was seeeking for a weeks. Thanks lot.
You are welcome!
I just made the most glorious Macro!! Thank-you so much, you spare no details!!!!
I am not sure. When is doubt, delete recorded Macro and try again. That's what I do.
You have a great teaching style. Appreciate your great video . Best regards
Nice job Mike. Tough to perfect the Macro recorder, I always push the wrong button and have to go back and redo frequently. thanks.
Your the man! Exactly what I needed! I couldn't figure out how to get my data to start in a new row. This was perfect, Thank you for putting your time into this!
you probably dont care but does any of you know a trick to log back into an instagram account..?
I stupidly lost my password. I love any tips you can offer me!
This is very well explained. Thank you
Glad it was helpful!
Part 2 did not appear yet...
Thank you Mr. Garvin for put a video about Macro, it was very nice, for give simple idea about it !!! Do you have other videos specifically for Financial Analyst ? I am learn about dashboard right now !!!
Great video. Start record from 5:35.
Ahh we know that you know how to write codes! You are just being humble!
This is letting the Macro Recorder write the code!
Great video and very helpful instead of having to learn the code. It took a couple of times of making mistakes and redoing the macro, but got it to work perfectly!!
Cool!
ExcelIsFun Do you have a video on how to get data that meets a criterion to appear in another worksheet? I've found other videos that demonstrate using the Advanced Filter option, but I cannot get that to work (get an error), and not sure if that is the best solution.
So as an example, I have data regarding providing project quotes and each have a status code. I want to use the status code to break up the projects into different worksheets, so that a person doesn't have to go through the entire data table or use various column filters (keeping the individuals from needing to access the data table to maintain data integrity). :)
For advanced filter, maybe: Highline Excel 2013 Class Video 37: Excel Advanced Filter Extract Data 26 Examples Basic - Advanced
for formulas, maybe: Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through
Thanks I will check them out.
You are awesome. I am your big fan. Thank you so much.
This video was EXACTLY what I was looking for! Thanks!!
Cool! I am glad the this video helped!
Excellent! Perfect macro for my project. Your instructions are so easy to follow.
l LOVE ALL of your RUclips videos. :)
Would it not be a simple "work-around" to have this work, when there are no existing entries, to CLICK the LAST CELL at the bottom of COLUMN A and then ARROW UP to "Jump to the top"?
Just started learning Excel last week, thanks for all of these great videos. You're an excellent instructor.
You are my favourite You Tube channel !!
Yes, you must have one record in the table before you record!
thanks, this is the most easiest way to transfer data without typing complicated
codes to which i cant understand it.... upload more...
Great explanation! Thanks!
This worked for me and this is very awesome. this saved me a ton of effort not to mention time.
At least I find the correct solution, thank you!!!!!!
Perfect explanation... Do u have more applications on recorded Macros? I jus find ur explanations so good and easy to apply by seeing ur applications
really good n easy to learn too.
Hello. Congratulation first of all for your videos and thank you very much. I have learned a lot from your videos which made my life way easier in my daily work. I wanted to ask you if do you have any video for VBA tutorials or do you plan to put on RUclips such videos in the near future? Otherwise may you recommend to me any place where to start learning VBA? Thanks and GOD bless you.
Me too! I very often click the wrong thing while recording. Then I have to stop, delete macro and start again!
Just found this range of videos - they are truly brilliant - thanks for all the work!
I just have one question, can you point me to a video where i can filter rows of information into different (defined tabs) once a cell fits a specific criteria. (the information in the cell will dictate what tab the entry goes.
hope im making myself clear, thanks in advance
This was exactly what I was looking for. Thank you
I am glad that the videos helps! Here are more Recorded Macro videos:
youtube [dot] com/playlist?list=PL68B3F66EEB526D5B
I struggled to make this work too. I then tried adding a title above the table headers and this did the job. (It could possibly be a hidden row or use white text on white?)
truly magic.click....
Thanks Man! You Are a life saver
This i very useful! Just what I have been looking for for the automated audit sheet that I have been trying to create for my employees' Image and Uniform Audit. Thanks a lot
Thanx very much for your work.......
What is not working?
This is GREAT! Thanks for sharing your knowledge
Awesome video, I'll definitely be using macros!
It's a great video. Can you create a video on how to edit an entry using a macro?
as always the best Teacher and Perfect video and example :D thank you!
You are welcome, En A!!!! Thank you for the support : ) : )
Awesome Sir... Very nice Session
Great video! I wonder if u also have a tutorial explaining how to create a matro which would to move data to a specific category (the number of them will be limited from the drop-down list) in the table. Thanks for any suggestions in advance!
Thanks for these amazing tips
You are welcome for the tips, Gustavo!!! Thanks for your support with your comment, thumbs up and Sub : )
This really what I need thank you very much! can I ask if you know or could you make a video that allow you to edit all the entries you've been created with this video without going to the table? just like what you did but now instead of new entry the cells c5 and c6 or even c4 can be change via macro?
Hi, thank you for the video. This is exactly what I was looking for!
Nice one again Mike easy to follow :)
You are amazing thank you for your video, i have a question how to do copy paste to another worksheet using macro like you explain here but for filtered data please ?? I always get a incomplete rows after run the macros, appreciate if you can tell me how to do this 🙏thank you.
What an excellent video. This has really helped my year 10 class with their spreadsheet development. Thanks :-)
Thank you very much.
finally, you did a macro video ...:)
Mariam Dear...
Ctrl+Down arrow Key for "Jump to Last value in Row", Or You Should "Jump to Last Row",
Same as it...
Ctrl+Down Up Key for "Jump to First value in Row", Or You Should "Jump to first Row",
You Also Apply key right key and left arrow key
I hope you will understand ;)
Hello,
Thanks very much for the video. I am following and learning a lot. Currently I am trying to create a macro which follows the same procedure as video. Problem I am facing is "It is not pasting the first value and everytime overriding". Please advice.
Excellent 👍
thanks for every thing. it's really helpfull. thanks alot
awsome.... thank you very much....
Thank you for educating me on the data entry process, it was really helpful.
Can you help me with how do i modify the code to apply this macros on a protected sheet. In other words - i wish to run the similar macros in a protected sheet as i do not users to be able to edit the contents of the table.
Hi Mike,
Thanks for the video. Is there a way to avoid making/copying a double entry to the Table sheet by mistake?
Thanks,
Thank You very Much for Vedio
Mr excel, one observation - the macro works provided we have added 1st record on the table;
Should there be no records to start with, then the last row cell gets selected?
You just made my day!
Nice video I liked it...
Great video thanks for sharing!
thanks bro so helpful
For VBA questions, try posting question here:
mrexcel [dot] com/forum
Many VBA masters at this site.
That is just what I was looking for! Thanks.
I found you through a "referral" from ExcelVbaIsFun.
Absolutely loved the video. Was hunting for that function since ages.... Thanks !
Nice work bro
nice tutorial, you can also create a data entry software and there is a readymade form in excel ribbon in excel option
Since I do not actually know how to write the VBA code (instead of getting the Marco Recorder to do it for you), I do not know how to do that. It is easy though, if you can write VBA code. This is a great alternative site (not affiliated with excelisfun at RUclips) where you can ask Excel VBA questions:
mrexcel [dot] com/forum
Excellent. Thanks. I liké it
Sorry, I had one other question. There's a place in the video around 5:55 where you need to use ctrl-down arrow to make sure it selects the next empty cell to add to. But if I use that when there is no data yet, it brings it to the last cell in the worksheet rather than the next cell with no data (with or without transition keys). So that shortcut seems to work if you have data in the table already, but not if you're trying to add the first item in the table.
It sounds like you may need hand written VBA code to solve your two problems. I do not know how to do that. You might want to try the alternative site (THE best Excel question site):
mrexcel.com/forum
+ExcelIsFun Hey! Ashay To The Rescue Use
Cells (Rows.Count, "A").End (xlUp).Select
It Will Work No Matter How Many Rows Of Data (Even 0!) In The Cell Object "A" Represents Column A
+ExcelIsFun Sorry It is Cells(Rows.Count, "A").End(xlUp).Offset (1, 0).Value = "Visual Basics For Application"
+Ashay Dwivedi where do I add this code in my macro editor.
Shekhar Dhiman Please Put Your Code In Here As A Comment So I Can Edit It
amazing amazing amazing. Thank you so much for posting this video!
nice one sir
Great!
Thumbs up!
this is great and very helpful, would it be possible to create a macro on the same first sheet to find and remove the data from your table by just putting in say the ID, and it wipes all the information from that row for that id. thank
I would just add the first record and then go from there.
Very Helpful video. Need one more help. Let's say if i don't want to enter date every time how for fix that?
THANK YOU!!! this is very helpful!!
Is it possible to Move Data To Table On Another Workbook using record macro function?
I can't believe this is possible! Woaahhhh.
Glad the video helps, Sean!!! Thanks for your support : )