Hi Guys,

You guys always give me such great advice so I thought I would ask for some help. So I have a large workbook of multiple constants and formulas and constants I am looking to convert the whole workbook between different currencies like dollars, euros,pounds etc. So How I would like to do this is add another column to each sheet and basically enter a currency symbol like $ or € and if that row in the new column contains that currency character then it will multiply the whole row by a conversion factor. I am pretty comfortable with if statements and DIm ranges and all that but I feel a little confused on this one. How would you guys recommend I go about this? an example of many a few lines of the code would be really helpful. Thank you so much for reading this and i appreciate any help.

best,
Your friend!