Sheet "Forecast" has rows with different categories, and also rows that include CURRENCY names such as "US Dollar", "Swiss Franc", ... In these rows there are at some cells amounts in number (eg 100).
I n sheet "Currency" I have a table with rows of all possible curreny names (eg US Dollar) and to the right there is the value it needs to be multiplied by so it shows the euro amount.
SO the macro I am trying to build should:
go through each cell of the column in "Forecast" sheet that includes the currency names, if the cell matches a name of the currencies from "Currencies" sheet table, then it should get all values of the row where that cell is and if they are numbers multiply them by the value to the right of the matched currency.
It is my first time with VBA so this is my first (completely wrong) code for it.:
Please Login or Register to view this content.
Thank you everyone for the help
Bookmarks