Forum Discussion
Update Daily Exchange Rate to a spreadsheet everyday to a new date
I have a spreadsheet that updates the daily exchange rate to a given cell. I have a column of dates that I wish to have that given date equal that day's rate without changing the previous date's rates. I have tried IF AND formulas that return the correct info to that day's date but change all previous dates to "FALSE". Other VLOOKUP formulas return #NAME? or #VALUE!. Any help would be appreciated. Thank you
7 Replies
- Could you post a quick example file of what you are trying to do.
It's not too clear from the description sorryTHank 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.
If you are trying to keep a history of the rates on particular dates then you will need to use a macro to run a copy paste values routine.
I've fixed up a couple of the formula but I don't think you can do what you want to do using formula
