Multiply a whole row of constants by a constant if an "X" appears in column B

[marvinabou7890]

Hi Gys,
So I have asked this question here three times and still no working reply. Hoping someone can help me this time. So I am trying to create a macro which will multiply all all the constants in any given row if there is a "X" in the correspong B column of that row. I have a macro which will work for 1 sheet however this has to work for many sheets and this entire problem is getting really frustrating. I will put the code please help me if you can.

Please Login or Register  to view this content.

[TMS]

You might get more help if you posted a sample workbook with some typical data and indicate what you would expect to get from running the macro.

regards, TMS

[Norie]

As it is code like this will only apply to the active sheet.

Please Login or Register  to view this content.

PS Why do you have loops for setting the value of one cell?


Which sheets should the code work for?

[joe31623]

Can't you just change Range("C" & i & ":F" & i) to Range("C" & i & ":F" & i).Cells.Value = Range("C" & i & ":F" & i).Cells.Value*coef ?

I'm not sure why you're using the Evaluate function, but if you need some kind of IsNumeric test, that could be incorporated as well.

As suggested, I'd recommend posting a sample sheet with a worksheet that contains raw data (or a subset of it) and a worksheet that contains your desired results because even if the change made above works, it's inefficient.

[marvinabou7890]

Hi,
Okay good idea. Attached is a toned down idea of what I am trying to do. If cell I2 in the config sheet equals "Euro" then all the cells rows throughout the work book with an "x" in column B should be multiplied by a constant lets call the constant cell I3 of the config sheet.
Thank you so much,
God Bless

[marvinabou7890]

HI guys,
Thank you for the reply. First the loops exist because this was meant to convert currencies of selected rows. I will eventually take the correct code and apply multiple IF statements to it so it could work with multiple currencies the names of the currencies will all be inputed in to config cell I2. the coefificients for each currency will be different and will exist on the currency sheet. Sorry that this is confusing. Thank you all so much,
God Bless.

[marvinabou7890]

Hi guys,

attached is a better version if you still are not getting what i amt trying to do sorry for the confusion. Hopefully this helps. So basically if config(I2) equals "Euro" then all the rows that have a x in column B should be multiplied by cell A1 on the currency sheet. The rows being multiplied should multiply from row C until say row K. the same condition should apply for if config(I2) equals say Peso. it should multiply all rows with an "x" on column B by cell B1 on the currency page.
If I cam provide anymore clarification please ask.
God Bless.