Macro that Adds 1 to field until two conditions are met.

Hello,

I need help creating a macro on the sample file that i've attached. I would like the macro to check if Column E < .75 and Column I > .85, if so then do nothing. If not, then keep adding 1 to Column C until Column E < .75 and Column I > .85.

I'm very new to macros and was trying to use the Do Until loops but couldn't get the hang of it. If it's helpful there will always be 48 rows so one condition could be Do until i = 48 but then i'm not sure what to do with the other variable or if it's nested or not.

Any help would be appreciated!

Thanks,
Zach

Thank you! I made some adjustments for my purposes and that seemed to do the trick.

Please Login or Register  to view this content.