Copy row data to another sheet based on column value

[trailrider120577]

I'm new here and have been going through the archives and haven't found what I'm looking for yet (still searching).
I'm looking for a macro that will search through worksheet called "1st Run" when it finds "1D" in column G it will move all of the information in that row A:G to worksheet "1D_1st_run" A:G starting at row 2 and do this for all rows. 2 through 1500.

Column G on worksheet 1st Run is a formula and I only need the value copied over.

I'm aware I can do a filter and only copy the information over needed. The problem is I'm needing this to be very fast and thought a macro would speed up the process.

I appreciated any help you can give. I'm fairly new at writing macros in excel.

Thanks,
Matt

[trailrider120577]

Ok, after some searching I was able to come up with the code I needed to do the part of sorting them into separate worksheets. Now comes the logic part that I need some major help with. I split the data down from each race per each division.

Now I need to generate the top 30 for each division per race 1 and per race 2. The top 30 for each division in each race (which could be more after people are removed and people added) is generated by the following:
If any person qualified more then once then their slowest time is removed from the division of their slowest time and then then next person after the top 30 from each division/race is added to the division where the person was just removed. This is repeated for every division. Is this possible to do?

I have the following worksheets:
1st Run - contains all of the results from race 1 sorted by their division placed.
2nd Run - contains all of the results from race 2 sorted by their division placed.

1D_1ST_RUN - Contains all people that placed in division 1 from run 1
2D_1ST_RUN - Contains all people that placed in division 2 from run 1
3D_1ST_RUN - Contains all people that placed in division 3 from run 1
4D_1ST_RUN - Contains all people that placed in division 4 from run 1
5D_1ST_RUN - Contains all people that placed in division 5 from run 1

1D_2ND_RUN - Contains all people that placed in division 1 from run 2
2D_2ND_RUN - Contains all people that placed in division 2 from run 2
3D_2ND_RUN - Contains all people that placed in division 3 from run 2
4D_2ND_RUN - Contains all people that placed in division 4 from run 2
5D_2ND_RUN - Contains all people that placed in division 4 from run 2


So lets say Jim placed in the top 30 in the 1D_1ST_RUN and then he placed in the top 30 in 2D_2ND_RUN. He would be removed from the 2D_2ND_RUN. Then the person that placed 31 in 2D_1ST_RUN and the person that placed 31 in 2D_2ND_RUN would make up the new TOP 30 for 2D_2ND_run. This would be repeated until all divisions are created for Run 1 and Run 2
Thanks,
Matt