I have a Web Query which pulls exchange rate details off of a website every 60 mins.
I would like to create a table like the one below that references those exchange rates and will only update an exchange rate if todays date is between the dates listed in Column A and B. When the date range has passed, I want the last updated value to remain indefinately.
For example: Cell C3 contains 0.66 which would have been last updated on 31st Jan 2011. I want this value to remain and then Cell C4 would be the active one updating until 28th Feb.
Column A Column B Column C Column D
1 Date___________________Exchange Rate
2 _______________________$-£________€-£
3 01/01/11 31/01/11______0.66_______0.8470
4 01/02/11 28/02/11______0.64_______0.85
5 01/03/11 31/03/11______0.61_______0.856
Can anyone help. Thanks.
Dan
I would like to create a table like the one below that references those exchange rates and will only update an exchange rate if todays date is between the dates listed in Column A and B. When the date range has passed, I want the last updated value to remain indefinately.
For example: Cell C3 contains 0.66 which would have been last updated on 31st Jan 2011. I want this value to remain and then Cell C4 would be the active one updating until 28th Feb.
Column A Column B Column C Column D
1 Date___________________Exchange Rate
2 _______________________$-£________€-£
3 01/01/11 31/01/11______0.66_______0.8470
4 01/02/11 28/02/11______0.64_______0.85
5 01/03/11 31/03/11______0.61_______0.856
Can anyone help. Thanks.
Dan
