I am creating a worksheet that I would like to be able to use a pick list for a country and this would be linked to an exchange rate in another range of cells. From there, I would like to have my price column to change to the new rate with the proper symbol. Anyone have a clue on how to do this? I have seen VBA on formatting the cell. I am familiar on how to change cells with a picklist; however, I have never have all these at the same time.
Any assistance would be great.