Split data in table into 3 tables based on column value

[adelkam]

The table contains score records in the "Data" worksheet as follows:
Team (column D), Score (Column E), and Rank (Column L).

I need to split the data and copy into 3 tables in different worksheet "Scoreboard" according to the following criteria:

- Copy "team & Score" with highest 10 ranks (i.e. rank 1-10), into the table titled "Tier 1" in "Scoreboard" worksheet
- Copy "team & Score" with the next 10 ranks (i.e. rank 11-20) into the table titled "Tier 2" in "Scoreboard" worksheet
- Copy "team & Score" the last 10 ranks (i.e. rank 21-30)into the table titled "Tier 3" in "Scoreboard" worksheet


I am attaching a sample file which clearly show what I need to accomplish:

I posted this in another forum at:
http://www.ozgrid.com/forum/showthread.php?t=194627

Please make best efforts to respond there "if possible". Thanks