I am hoping this is going to make sense.

I am looking for a macro that will filter data for me, but from the value inputted in a specific cell.

For example i have three team competing and four age group of athletes.

Each team can have an unlimimted number of athletes what i want the macro to do is filter the data by team take the top four athletes from each team and paste it on to another sheets.

What i am struggling to do is when the data changes or the team name changes. the macro doesn;t allow for this.

If you need more information then please let me know.

regards
Nathan