Right now I have a sheet with one of my cells containing a PASS/FAIL drop down. What I'm looking to accomplish is when the FAIL option is selected, all the data in that row (Cell A-S) is copied and pasted into a different sheet(tab). This would result in just a sheet with fail data. I know I can copy and paste, but there is going to be a large amount of data, and a fairly high rate of human error possible, so this could stream line things quite nicely.
I hope this makes sense.
Thanks.