Copy X Number of Rows Based on Checkbox, and Calculate High Point?

[djpony]

I'm working on a large spreadsheet for a horse show association to be able to calculate the high point winners of each division, and seem to be stuck on some VB code!

Here is what I am trying to do:
((On Open High Point Tab))

1) There is a "Calculate Open High Point" button. When pressed, the code should look at each tab (Sheet 1, Sheet 2, Sheet 3, Sheet 4, etc etc, Sheet 214 *For my example I shortened the sheets to 5 so that the forum would allow me to attach)) and see if the checkbox for "Open" is checked.
2) IF there is a check on the box, it then needs to look at the number of entries in the class.

**For the above two things, I have already figured out the code to get this info printed onto the "Open High Point" tab. Again, I only tabs included in the attached for classes 1-5, but am planning on copying it for the rest of the classes (214) as well.

Now here is where I get stuck/completely lost!
3) The code needs to look at each class, and IF there are entries in the class, then it needs to copy the entire row (Class Name, Back #, Name of Horse, Exhibitor, St, Owner, and Points) from that tab (Sheet 1, Sheet 2, etc etc) to the Open High Point Tab. The code needs to look at the number of entries, and only copy those lines.

4) After all of the Open Entries and their points are copied, it then needs to add together the points for the like Horse/Rider combinations (so Name of Horse must = Name of Exhibitor), and then list them in order from largest amount of points to smallest. There CAN be instances where one person will show one horse in one class, and another person will show the same horse in another class, and we just need to make sure the high point calculations remain horse/rider combination specific.

5) The code also needs to clear the previous calculations when the "Calculate Open High Point" button is hit so no rider/horse combination is awarded more points than they should.

I tried to explain this the best that I can, but feel free to ask any questions! I'm also attaching my file to this thread. Keep in mind that I'm sure most of the VB coding that I have in there already is junk - I've been trying to find old threads that do what I want and piecemeal them together, which has definitely NOT worked out.

Thanks to everyone in advance for your help!!!

Heidi

[djpony]

Bumping up! I hope someone can help!

[jwhite4343]

Did you ever get help with this? I'm actually working on a similar spreadsheet myself.