excel - VBA macro for converting value in various currencies into USD

Question

I have a table with populated Column A ('Currency') and Column B ('Value'), and empty Column C ('ValueInUSD'). The table has thousands of rows, each for different transaction in 6 different currencies. Column A, contains currency name (text). Need a macro, which will carry all these exchange rates to USD (which will be updated by me on weekly basis), and will populate Column C ('Value' * Exchange Rate), for the whole table. Alternatively, I can hold the small table with 6 currencies exchange rates in separate excel file, and the macro would refer to that table, to get the respective exchange rate for each cell in Column C ('ValueInUSD'). Could you please help tackle this problem?

question from:https://stackoverflow.com/questions/65873272/vba-macro-for-converting-value-in-various-currencies-into-usd

Answer 1

Waitting for answers