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.

Added some more validation to the Last Shows tab of sheet.

Updated the show tracking sheet 

I noticed some of the show names had changed in my feed so were not updating the cache columns. So I added a column between the feed columns and the cache columns that checks that each show in the feed is in the cache and turns green if it is #N/A then you either need to change the name in the cache list or add it.

Added a bit more automation to the sheet.

Updated the show tracking sheet 

On "Last Show" tab I added some columns. 

Now all the shows are listed in F and the last seen episode from the feed is compared with the last saved in G. The greater of the 2 is placed in K and the matching date in L. Also you now force and feed update by changing the date in F1. Conditional formatting should turn the cells in columns K and L green in the rows where the G and K cells match (do not need updating). After updating the feed, copy the cells from K4 to L110 then paste the values into G4 to store the "last in feed" data.

On the "shows" tab I added some columns.

The parsing of the "Last watched" and "Last show" columns outputs into 3 columns now to handle those times when unexpected text gets parsed into the cell. The parser now works differently for the 2 formats

The "diff" column now uses a different method for calculating the number of unseen episodes available for the season-episode vs date formats. This should give better estimates.

The "Last show" column now looks at column F to look up feed data exclusively (instead of first checking the feed and only checking F if not found) and takes the value from K. This should deal with the problem of shows dropping off the feed at the end of seasons.