My initial problem was this:
Ihave a coworker that maintains a spreadsheet comprised of several tabs, thefirst is the main and contains all the information about each business partnerwith columns showing their 1st choice wholesaler, 2nd choice, 3rd choice and soon. And then there's a tab for...