Convert sale amounts ..

[gacid]

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.

Screenshot here: http://imageload.dk/files/4808fd8cae...970e809953.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:
One more screenshot http://imageload.dk/files/e16871ee6c...df75986cb5.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":
Workbooks.zip

[royUK]

An example workbook would be much better than images

[ravishankar]

Hi
preferably in XL 2000/2003 format since not many have access to 2007
Ravi