About Financial Modeling Macros
Macros may be useful when you want to automate a manual process you need to repeat many times. In financial modeling, macros are not typically required, although they may be used for things like deleting all assumptions in a template (resetting the template) or extracting data from other files and populating it into spreadsheets.