Get specific data and copy particular fields to another sheet

I want to check one particular column for a particular value, if it equals that value I'd then like to copy particular columns from that row onto another sheet, then move on and look for the next one that satisfies the same criteria.

Once it has found all of them and copied them, I'd then like it to go back through the same data and look for a second criteria and do the same thing.

On sheet 1 there are 6 columns (A through F) and I want to check if F = 1, if it does I would like to copy the contents of columns A, B, D, F of the same row to sheet 2 starting from A22 and continue through until I have found each row where F = 1

Once that is done I'd like it to go through the same data on sheet 1 and look for where F = 2 and copy the same columns A, B, D, F contiuing on from the next row of sheet 2 where the last data was copied to.

I have attached an example speadsheet.

Thanks in advance for any help.

How did you get your ranking?

First option would be filter on the rank.

Here is your second option Array formula ( CTRL + SHIFT + ENTER )
In Sheet2 -> A2

Formula:

Please Login or Register  to view this content.

drag right and down... delete the unwanted columns.

Edit: I Forget to wrap the formula above with iferror() for error handling. =iferror(theformula above,"")

I have actually managed to fix this for myself and thought I would show the answer for anyone else looking for something similar.

I did change one of the criteria slightly however and removed the columns that had data I didn't want in it, so I didn't have to choose specific columns to copy, just the row from column A to D for example

I did it through adding a button to the worksheet and adding a module in VB - The solution example is attached

Please Login or Register  to view this content.