gacid
11-14-2008, 07:03 AM
Hi all. I got problems with a (for me) diffcult VBA-code.
Here it goes:
There are two Excel files with data that are necessary in order to solve the job. The file "SalesAmount.xlsx" contains a list of sales amount and the currency they are denominated as. The file "ExchangeRates.xlsx" contains a list of the currencies and their respective rates/prizes.
http://imageload.dk/files/4808fd8cae5fa2c193c591970e809953.JPG
ExchangeRates.xlsx : last row in this worksheet is 39
SalesAmount.xlsx : last row in this worksheet is 328
Now the job is to make a top 10 list of the largest sales measured in Danish kroner (DKK), which of course requires that all amounts are converted from their original currency to DKK.
It could look like this:
http://imageload.dk/files/e16871ee6c33665dce62e7df75986cb5.JPG
I just dont know how to make. Hopefully someone can help me out :)
Regards
The last picture, is the workbook I want to make.
EDIT: Here is the two workbooks "SalesAmount.xlsx" & "ExchangeRates.xlsx":
10743
Here it goes:
There are two Excel files with data that are necessary in order to solve the job. The file "SalesAmount.xlsx" contains a list of sales amount and the currency they are denominated as. The file "ExchangeRates.xlsx" contains a list of the currencies and their respective rates/prizes.
http://imageload.dk/files/4808fd8cae5fa2c193c591970e809953.JPG
ExchangeRates.xlsx : last row in this worksheet is 39
SalesAmount.xlsx : last row in this worksheet is 328
Now the job is to make a top 10 list of the largest sales measured in Danish kroner (DKK), which of course requires that all amounts are converted from their original currency to DKK.
It could look like this:
http://imageload.dk/files/e16871ee6c33665dce62e7df75986cb5.JPG
I just dont know how to make. Hopefully someone can help me out :)
Regards
The last picture, is the workbook I want to make.
EDIT: Here is the two workbooks "SalesAmount.xlsx" & "ExchangeRates.xlsx":
10743