I'm not sure if this goes here or in handicapping but I'll start here.

My little database program crunches data from up to a years worth of races and then outputs it to a comma separated values (.csv) file that I then open in Excel and do my analysis. Once upon a time I also had an analysis program but it was extremely awkward to use and even more difficult to modify. Excel is much easier.

So I run the program and now I have this large .csv file that I want to analyze.

First I sort the data by surface and distance. I recorded a marco to do this but after that, I have to manually* copy all the dirt sprints, dirt routes, turf sprints, turf routes to separate sheets in order to do more specific analysis. I need a marco to do this work for me.

I can record simple macros, like sorting by surface and distance, but in order to move dirt sprints to the DIRT SPRINTS tab, the macro has to be able to tell if column E is D(irt) or T(urf) and it has to tell if column D is greater than or equal to 1100 but less than 1760 (yards).

While I am sure I could figure this out (given enough time), I was wondering is anyone has this already worked out and could slip me a spreadsheet with it in there?

*I know, first world problem, right?