Change a whole row based off one column macro!!!

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!

Hi guys,
Basically all I want is a macro that say says in column B for any cell that has an "x" multply the corresponding row by a number say 5. but this has to run based on another cell like if cell F2 says euro then run that code and multiply by say 0.97 or something. Anything helps.
thank you guys.

Hi,
I really can't I am sorry this is very sensitive information for my job. But what I can tell you is I am trying to make an if statement that basically says (if any cell in column B contains "X" then multiply the rest of the row that has the ("x") by 5) That is really all I need. every other cell in column B that doesn't have an X will just be empty. I will hide this column at the end. I am just very confused on how to write the above if statement. Anything helps.
Thank you all so much.

an example of the code I have so far but it doesnt work

Please Login or Register  to view this content.

Hi,
Thank you for replying but this will not work.
Basically I have a large data set with column A containing names abd every other column containing numerical values where some rows are contants and some rows are formulas from other sheets. What I need is an If statement which says (if any cell in column B has an ("x") then multiply the rest of that row i.e column C to say Z by a numerical value in this case say 5). Cell I2 is just where I will put the numerical value to multiply by when I run the macro. Anything helps.
Thank you.

Hi,
Also in this case I named column B "configpgb"
thank you

Hi,
YES!!!! that works you are amazing thank you so much!! I added the if part and it is awesome thanks you.
Cheers,
Your friend

Hi,
Thank you again. I am trying to add more sheets to this macro for the work book is large and I would like it to work across more than one sheet at once. I will add the code I have below maybe you could help me be able to make this work for multiple sheets?

Please Login or Register  to view this content.