Picking Information from a list

E

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.....
 
D

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
 
Top