Help create code to pair like items at random

**SAFD1450** · 01-26-2011, 02:05 AM

Hello and thank you to anyone that can try to help me.

I have some experience with excel and consider myself a little above an average user, but I have never really programmed macros/vba before.

What I am trying to do is create a list that will pair two dogs at random, but they need to be within 3 lbs of each other, not from the same owner, and they can only be shown once. Each owner will have between 1-3 dogs to show and there could be up to 20 owners per show.

I have included a quickly thrown together example of what I am trying to do. I locked it because I only want to allow entry into columns C, D, & I, but there are no passwords so you can remove it to make changes.

If possible I would like a macro/vba button to calculate column I after I manually enter C and D and a second button to clear columns C, D, & I after I have the results so I can do it again.

I hope this was all clear enough, thanks again to anyone who will help me.

Scott Adams

**SAFD1450** · 01-26-2011, 08:39 PM

Can anybody give me any ideas at all?

**SAFD1450** · 01-28-2011, 12:11 AM

One more try.... Please!?

**shg** · 01-28-2011, 12:42 AM

I don't have a VBA suggestion, but think you could do this manually if you simplify the layout.

Sort the dogs descending by weight. Start with the heaviest dog and pair with the next heaviest having a different owner. Conditional formatting shows remaining dogs available for selection.

**SAFD1450** · 01-30-2011, 01:03 PM

Thanks for the help, but I am trying to make it extremely easy to use. The people that will be using this do not understand excel, so I just want them to enter the weights, press a button, and then print.