How to create your own VBA Macro (for dummies)
Did you ever worked hard all your way through fixing the Excel/sheets format your way for each file/sheet all day long and always wished for a magic wand to do that for you in a jiffy?
So here it is. A very cool way indeed!
Step 1. Create a sample file with sheets with your desired data placed within it.
Step 2. Record macros as you would create this sample sheet.
Step 3. Sequence the steps of the recorded macros and create a master macro and call all other macros inside it as below.
SUB Main ()
Call Resets
Call Conv2Val
Call Format_Table
End Sub
Look here at the video how this made my Excel files work efficiently and save me some extra time to spend with my family 😊