Get the data file here for free: https://drive.google.com/file/d/1EwJS...
To automate Excel tasks using VBA macro, you can use the Macro Recorder to record your actions and generate VBA code automatically. You can also use the Visual Basic Editor to edit and write your code.
Excel VBA Macro series: • Excel VBA Macro