Pull entire row to new sheet based on number value in end column

[cbeck]

Ok the data set is this, One sheet has text and number columns, including a "score" in the final column. Based on the score column, I would like to pull entire rows if value =1 and see ONLY that row in a second sheet. Simple vlookup wont work as there are possibly more than one row of data that will have a score of 1.

Please let me know if you need more

[Pete_UK]

Do you want to MOVE the row into the second sheet, or to COPY it so that the original stays in the first sheet?

It might be easier to understand what you want if you attach a sample workbook (the FAQ describes how to).

Pete