I have two worksheets:
- "People" (shows unique salesperson ID, name, and basic info about our sales team members, with one row per salesperson)
- "Sales" (shows details about each sale, with a foreign key back to the salesperson ID, with multiple rows per salesperson).
I have a VBA userform...