Using Relative References when Recording Macros

When selecting cells whilst recording a macro, the macro records these as absolute references. You can toggle between relative and absolute references during a recording to get the correct behaviour from your macro.

This tutorial covers;

• Recording a macro that consolidates data onto one worksheet
• Using relative references in a macro
• Viewing the VBA code generated by the recording and editing parts