Recalculating Figures with Currencies

[mrosendal]

Hi all

I am very thankful for all the help i am getting on this forum.

I have been given a quite difficult task regarding Sales figures and currencies. Since there are sales in different countries and currencies these need to be converted in the Native currency DKK.

1. I have 2 Sheets, One has all the sales figures and the other has the Exchange rates of the currencies needed.

2. First thing will be to generate Makro which can Multiply the Sales Figure on book 1 with the Currency on book 2, Then dividing it by 100 to get the correct sales figure in DKK. e.g (s.fig 10000 * 594,568 (USD rate) / 100 = 59400 DKK)

3. When VBA has these figures in DKK they will then have to be put on a new workbook ("results") With 2 seperate Sheets, Sheet1 to view all results on a descending list.

4. Sheet2. Will be used to view a top 10 of the sales figures in DKK for 10 selected currencies. (GBP, NZD, SEK, NOK, EUR, RUB, USD, JPY, ISK and DKK).
So the highest numbers corresponding to those currencies on the results list.

Hope this is not to difficult to get done. I have started with declaring some variables i think will be needed to complete it.

I have also attached files to work on.

Thanks in advance