Find and select cells that meet specific conditions

[Grahamfeeley]

Find and select cells that meet specific conditions
Looking for top 2 in column G
Select all rows from row 2 ending where following criteria G column is "Won"
starting row B2
Highlight all rows and copy to Clipboard
Any help here will be appreciated as usual
Regards
Graham

[kersplash]

Can you attach a sample workbook showing what you want as a result for your sample.

Go Advanced -> Manage Attachments -> Upload

[Grahamfeeley]

Sample attached...thanks
Graham

[kersplash]

Are you sure that's the correct file?

[Grahamfeeley]

My Bad I did not check file before attaching
It is wrong file back shortly
Graham
Sorry

[Grahamfeeley]

add new file attachment'
Thanks

[kersplash]

For your sample can you give what you expect as the data to be copied? Mock-up the result manually.

[Grahamfeeley]

12:30 SwnH (AUS) (Place) (SIM) 14. Vogue Empress Back $63.32 $1.43 Lost $63.32
12:35 Graf (AUS) (Place) (SIM) 2. The Eulo Queen Back $196.27 $1.41 Won $72.42
13:10 Graf (AUS) (Place) (SIM) 5. Mustaknown Back $46.30 $1.73 Lost $46.30
13:25 Gunn (AUS) (Place) (SIM) 10. Madam Yoko Back $123.78 $1.74 Won $82.44


That is the required data
Thank you for your help
Graham