hi all
i'm almost certain this is possible i need to search through a spread sheet with 500+ names looking for people after a set time, i can filter alot out so i can narrow my search down, then i need to copy the names after a set time into a different spread sheet which in turn will tell me which team they belong. i just need either the macro if there is one or the vba to assist this operation. performing the copy and paste Technic killed my day.

regards
david