Change one column's value based on input conditions.

[pkldonovan]

Hi guys, I'm trying to write a macros where it changes the value of one column based on the input condition of the user.

For example:

InputBox A = 0.5
InputBox B = 1.0

Check the entire column A, if value of column A is >= 0.5 AND value of column A is <= 1.0, Then change Column B value to 1. If NOT, Do NOTHING.

Greatly appreciate your experts help.

[FDibbins]

you dont need a macro for this, a formula will do it easily...

in B1 use this =if(and(A1>=0.5,A1<=1),1,"")

if B already has values, you coulds put this in C1 and change it to...
=if(and(A1>=0.5,A1<=1),1,B1)

[pkldonovan]

Thank you FDibbins for your suggestion.

However, I need to make this change for 20 different excel files along with different conditions for each of them.

Also column B's original values cannot be changed if it doesn't meet the condition. Making a separate column C1 won't solve the problem.

[pkldonovan]

Here is some code I piece together after reading some forum helps.

I'm stuck at the part where I have met the condition, I need to change to the exact same corresponding B1 cell to value of "1"

Please Login or Register  to view this content.