Grouping algorithm

[nightingaie]

Hi everyone, I am a newbie both to vba macros as well as this forum. I've done one programming course in university but that was awhile ago.
I have done some research but still could not find anyway to even begin to generate something.

The problem has a few parts. I am trying to create a macro to cut down on my work calculating prices for jewelry resell. Basically I have a deal going that if the sum of a group of jewelry is equal or over $200, I can get one additional piece of jewelry equal or lesser than $75 for free. Due to the sheer number of calculations I have to do every day, I have decided to try automating this.

Here is my idea so far:
Basically, I will have a list of products, each with different prices. I want to optimize a selection of products such that for every $200's worth of jewelry I will assign it a group number, and assign the group number to one product that is below $75. But how will I go about generating this group number such that Excel knows to go through the entire column to find the pieces to piece together the most optimal choices that considers all the groups? And how will I take out the assigned product from the pool of consideration for when Excel tries to find the next group? There may be as many as 10 groups.

I'm not asking for free code, but if someone could throw me a bone and give me the functions that would help me that would be really helpful.
Thanks!
Jason

[FDibbins]

Hi, welcome to the forum

It would probably help a lot if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.