Hi,

I'm using a table in Excel to track product inventory, and I'd like to build in what seems like a simple function. I have a column for "Stock Level", which will say "Low" if the current stock falls below a preset minimum (or "Out of Stock"), which changes back to "Good" once enough stock is added to our inventory. I have another column, "Status", for tracking the status of items we need to order ("RFQ to vendor . . ."), allowing everyone to see what the status is, when to expect more, etc.

I'd like to automatically clear the "Status" column when the "Stock Level" column changes to "Good".

I am a total rookie with VBA, so I've tried running a loop that iterates through each row, and looks for Good in a given column (with the InStr fxn) but no luck!

Any help is much appreciated.

Thanks!