To recreate my results, click This Excel File and then "view raw" to download the stock data, then paste the text from my VBA Script into a module within VBA. Finally click the developer tab and run ...

initial.xlsm - Macro-enabled Excel file containing the VBA script; template.docx - MS Word template file VBA script replaces text in; initial data.xlsx - a dictionary of items to be replaced; sample ...

I've been treating Excel like a glorified calculator for most of my life. Sure, formulas made doing more complex calculations easier and automatically updated data, and there are free Excel templates ...