Selecting data by a percentaged?

[KingSwish828]

I have a little bit of a problem. I sort a file into categories and get the totals. Is there a MACRO or VBA code that I can use that will look at the totals for each category and select half of the data for each category and past all of that information onto another worksheet?