Returning row values based on conditional formatting variables
- by Mike Bodes
I'm not entirely sure how to properly explain this, but here we go...
I'm trying to create a single budgeting document that allows me to manage purchasing and reconciliation for multiple projects. I would like to create separate sheets per project and have purchased items populate on a master sheet.
Using conditional formatting, I've set one of the columns to display an item's status (waiting for approval, approved, ordered, received). I would like the contents of an entire row to populate in a new sheet table once the status is set to "Received." The sheet should update descendingly.
I can't attach an image because I don't have a 10 reputation.. Any help is greatly appreciated.