Learn the basics of Macros and VBA in Excel. Macros allows you to automate repetitive tasks in Excel. With the help of an example on you'll learn how to automatically format data in an Excel. Our data has different ranges so we want to record the macro in such a way that its dynamic depending on the size of the data. Instead of hardcoding a certain data range with excel macros we'll use dynamic cell referencing.

In our example we'll record a macro and then modify it with visual basic so, you'll also get a glimpse of how to work with VBA.

Practice File: [ Ссылка ]

Timestamps:
00:00 Intro to Macro
00:54 Intro of sample data
01:22 Two ways of recording macro
02:05 Recording Macro in wrong way
03:20 What went wrong
04:20 Recording Macro in right way
05:15 Testing the Macro
05:32 Problem with blank sheets
05:50 Fixing Macro with if condition
07:37 Closure

свернуть