It all started when...

I was working as an intern on the Digital Investments team. I had many projects that involved long processes in which I needed to create an excel tracker to log changes. 

There were two forms of reporting I was asked to analyze and send feedback to partners if I noticed any discrepancies. I began to notice duplicate steps in both processes, and went about optimizing correspondence with my own macros. 

I created a file which would allow any assistant planner to update discrepancies as noticed in separate sheets, and for any desired partner, I wrote functions that would collect all of the data for the desired reporting cycle, populate the main sheet, and even concatenate this information in an email body. 

This reporting tracker is now implemented in practice for the Digital Investment team at Havas Media.