I have quite a lengthy request and greatly appreciate any assistance. My supervisor would like for me to take data from an Excel pivot (where data selection can constantly change), format this data "pretty", and link into a PowerPoint slide. Oh, I also did not mention that both of these documents need to reside on a SharePoint site.

I thought about building an Excel macro (to either automate or run manually) to do the formatting prior to going to PP but I wanted to see if there were other suggestions or if this entire idea was too far fetched in the first place before starting. Thank you for any assistance!