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.
Bookmarks