All,
I'm working on a portion of a spreadsheet where I'm trying to minimize the amount of input the user has to do. I would like a few cells to use the info in one cell (the Quote #) and return a variety of information.
The user inputs the quote number. I want the name and territory to fill...