Picking Information from a list

[eddie84]

Thankyou for that. However, I am wanting to bring these across into
separate list which shows all the players registered for a club. Th
filter option doesn't help me with the moving of this elsewhere.
need the information in a different place as the information is goin
to be used to complete a team sheet automatically.

...... here's hoping.....

 

[Debra Dalgleish]

You can use an Advanced Filter to copy the data to a different sheet.
There are instructions here:

http://www.contextures.com/xladvfilter01.html

 

[Don Guillett]

Here is one I did for a client recently.

With Sheets("yoursheenamehere")
..Range("yourrangenamehere").AdvancedFilter Action:=xlFilterInPlace,
Unique:=True
..Range("yourrangenamehere").SpecialCells(xlCellTypeVisible).Copy
Sheets("destinationsheet").Range("b28").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
If .FilterMode = True Then .ShowAllData
'.Rows(4).Hidden = True
End With