Master Excel MACROS & VBA in ONLY 1 HOUR!

Can I record a ctrl+replace. I want to be able to hit a button and it replaces all of this year (year inputed in a certain cell) with next year (year put in another cell) but ctrl replace doesn't seem to be able to take info from a certain cell

very nice and much helpful in learning VB macros. Thank you so much..

New to macros and looking to export data from sheet 1 to sheet 2, but only pulling through certain columns, and changing the data in those columns when it lands in sheet 2. Any ideas?

What is up with the color in the video lol

Hello, is this course still offer those bonuses mentioned? I'm interested, but I don't know if I will still get the same value for the course. Please let me know. Thanks!

I have just found your site and this is exactly what I was looking for for sometime now. I consider myself an intermediate user of Excel but I want to improve my knowledge from a certified organisation such as yours. Please let me know if this online training offer is still in effect today. Thank you.

Thank you, very helpful

clear so professional and awesome - great job bro.

This is really good info. Thanks!

Thanks for the knowledge shared....

Hey, please help in VBA Codes for the work, i have workbook with 2 sheet, data available in sheet1 and same header available in sheet2, and the code should work for it will match the header and pull the data from sheet 1and paste it in sheet2 as per the header matched. if you share the code it will help me more. thanks

10Q

What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?

Wow! that's great

Hi the Video was too informative all i wanna ask is that if i want to for eg add a month July to my worksheet and then copy the july and paste till the end of the range and then i use the same macro in the other excel sheet where the is longer than this worksheet what can i do in order to get the data till the end of the range of the new excel worksheet

watching video feel like AVATAR teaching me😂

Hi how wpuld you find the percentage of two sheets in macro

Hello, when I uploaded the excel file to OneDrive, the developer tab disappeared, and I could not enable developer tab for the excel file stored in OneDrive. Please help!

1st time looking into Macros. Wasn't sure which video to start with. Glad I started with the right one! Excellent work! Thank you.

Export image VBA macro in matlab of cst microwave studio

Wow! one of the clearest explanations of VBA code. Thanks a lot

Hello sir,
The file is not downloading... I tried multiple times...

Thank you do much!

nice

Hi, this is a good vba Page.

I suggest these useful macros:

Workbook route in title bar
Workbook name in title bar
Highlight active cell
Highlight active row & column
Color tabs - worksheets
Uncolor tabs - worksheets
Number to letters

Thank you John & Kyle. It was really amazing; Mr. Kyle did an awesome introduction to Macros and VBA. God bless you both.

Nice content . Nice presentation with clear workable english. Excellent trainer & his knowledge..

Thanks you are good at it

Great Job Buddy . Extremely helpful..

Useful

Good Day sir,
Hope you can help. We had an employee leave the company and he changed the passwords fo rthe VBA editor on all of our templates. He had taken most of our templates and removed the menu bars and ribbons. We cant even use the undo feature. is there a way to find the password or remove it at least?

Hello why my customize macro ribbon menu is not working when I save_as my workbook with different name or when copy the file in different directory? Whereas the Macro File is exist tho. This force me to run the macro through macros menu. Could you help me?

It took only 17mins to realize how stupid i was … i would save a lot of my time and effort if i saw this 9years ago! Tks !!

The concepts are shown so very clearly. I would lie to learn about VBA coding and macros to develop automated dashboards. Could you please guide me. Thank you !

Man you are the best thank you for your efforts!

thanks dude, now monthly work, will finish in 1 day

the way you teach makes it so easy to understand , thank you .

I want to create new macro to replace given path to other tab as input given through macro

I have 2 questions.

1. How to define live month in in excel macro?
2. How to create dynamic filter?

I really liked this presentation easy to follow through

Thanks you very much blue men!
🎶im blue if i was green i was die🎶

Hi ,I went though a lot of video in you tube and found your explanation is very simplest way, Thank you Kyle.

i have a excel file having 21 sheets using micros. need to add more sheets

Awesome ! Your former student Kyle !!

VBA MODULE NOT AVAILABLE

No F. Idiot will say to master macro & VBA in 1 hour with half info provided.

Nice personality , clear and professional.