Saturday, June 24, 2017

Made Last Show tab update fully automated via a menu option

Updated the show tracking sheet 

On "Last Show" tab I added a column. 

Instead of updating the offset key manually and then copying columns now you just click the update menu item to do all the steps. 

This required adding a column to sort the feed data which still comes into column A. The macro updates the offset key with a current timestamp to trigger reimport of feed data. It then copies the data to column B so that is can be sorted (to get around the issue of older episodes sometimes coming higher in the feed than newer ones). Then finally it copies the diffed data in columns O and P to the cached data area.