load data into array, check condition, and paste back into sheet

Hi all,

I want to check the condition of multiple cells in a range without creating a helper column (for convenience and to learn more about VBA).

In my sample file, column A will stay the same, but values in column B have to be adjusted based on my condition (cell in column B divided by cell in column A should not exceed 0.95). I created two helper columns to illustrate what I want to achieve. Column C uses the cell reference of column B to check for the condition, whereas column D uses the cell value of column B instead. I assume this could be done with code by loading the values of column B into an array, then checking if the condition is met and pasting it back into the range?

What should happen if a cell in col B doesn't meet the criteria? change its value to 'warning'?

Try on a copy of your workbook.
Changes the values in Column B to 95 percent if it is more.

Please Login or Register  to view this content.

Originally Posted by jolivanes

Try on a copy of your workbook.
Changes the values in Column B to 95 percent if it is more.

This was a very good starting point! Thanks jolivanes!!

Below is what seems to work for me now, even though not sure if it's the most efficient solution.

Please Login or Register  to view this content.

Originally Posted by Akuini

What should happen if a cell in col B doesn't meet the criteria? change its value to 'warning'?

Yes, exactly! If the value exceeds 0.95 it should paste the string "Warning!". I simplified the actual output for explanation purposes.