griddle984
New Member
- Joined
- Mar 30, 2017
- Messages
- 3
Hello,
I'm building an electricity/utilities monitoring scorecard for a Chinese factory. We want to take a daily electricity meter reading, run formulas to determine the amount of Chinese Renminbi due on the bill, and convert the Renminbi to USD. This scorecard will keep a running tally with historical data from prior days - so each row represents a different day.
I've got a data connection table setup now to pull the foreign exchange rates from x-rates.com for current rates. Then I run a VLOOKUP from that data table to find the corresponding Renminbi value for today's entry. When my data table updates, it pulls the most up-to-date currency conversion just as I want which is great...but my excel formulas also update and the prior day utilizes the current exchange rate instead of the prior exchange rate. I've tried to make it easy and search for a web-link that has dates with each currency conversion rate but that's not yielded any fruit.
This spreadsheet would be used by various people with different computers so Plug-Ins will not work. I'd also like to keep VBA code out if possible -- but I can include if needed.
Any help you can provide is much appreciated!
I'm building an electricity/utilities monitoring scorecard for a Chinese factory. We want to take a daily electricity meter reading, run formulas to determine the amount of Chinese Renminbi due on the bill, and convert the Renminbi to USD. This scorecard will keep a running tally with historical data from prior days - so each row represents a different day.
I've got a data connection table setup now to pull the foreign exchange rates from x-rates.com for current rates. Then I run a VLOOKUP from that data table to find the corresponding Renminbi value for today's entry. When my data table updates, it pulls the most up-to-date currency conversion just as I want which is great...but my excel formulas also update and the prior day utilizes the current exchange rate instead of the prior exchange rate. I've tried to make it easy and search for a web-link that has dates with each currency conversion rate but that's not yielded any fruit.
This spreadsheet would be used by various people with different computers so Plug-Ins will not work. I'd also like to keep VBA code out if possible -- but I can include if needed.
Any help you can provide is much appreciated!