actually, each row is an item....and starting at column E is a step in a process with the item.

if the item is holding at the first stage in E.....a person would put HOLD....and so on. there should never be more than one HOLD listed in a row at a time.

I am able to Auto Filter....but kinda wanted to have a sheet that would just list all of the items that are currently HOLDING at any stage of our process.....and be listed on a seperate sheet for easy review.