I have already done a search to no avail, but if someone has seen this in another post, please let me know what to search for so I don't waste anyones time.
For a simple example, I have a range with a list of Sales People, and another range with the list of accounts. Here is an example:
Range1 Range2 Range3
Bob Smith Bubba's Shoes NorthEast
Bob Smith Xanadu's SouthWest
Gary Bob Ripunzels Eastern
Fay Bon Frickafrack Northern
Bob Smith Franks & Beans Central
Now what I would like to do is have a combo box with each salesman, then be able to pick a salesman like Bob Smith and have it populate cells with all of his acounts.
I do not need the whole program, just the direction on how to go about pulling and listing from one criteria. I can't use a pivot table, so need it to be a formula or VB line.
Any help is much appreciated. Thank you!