Update Daily Exchange Rate to a spreadsheet everyday to a new date

THank you for your interest in helping Wyn Hopkins. I have attached the file. It is macro enabled MSO2016. I use this worksheet in other work books to update the current exchange rates for the date of a given transaction as the rates do change daily. The Exchange rate at the top will update automatically or when refresh external reference is selected. I have been updating the right column manual. I know this can be done automatically without changing/clearing the previous date's rates. Hope this helps to explain what I am trying to achieve.