excel courses - Recording Macros

Hi Atia. Essentially, macros can be as complicated as you want them to be. The trick is to make the VBA code as "clean" and elegant as possible. You certainly can use macros to generate and reformat pivot tables, although ideally you need to do this within the Excel VBA environment itself as otherwise it can be extremely difficult just using the Macro recorder.

Hope this helps,

Anthony