| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I compile data entered using a drop down list
I'm trying to set up a worksheet where I can enter transaction data selecting
an individual sales person from a list. I've been able to use the validation tool to create the list, now I need to find a way to compile the data into a single line for each sales person. In other words, salesperson A may have only 5 of the 50 transactions over the week, and I need to find a way to seek only those 5 transactions, total them and post them in a cell. I've already exceeded my meager knowledge of Excel by creating the drop-down menu and have found myself hopelessly outwitted. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Trying to List data that is being entered into an Invoice | Excel Worksheet Functions | |||
| Limit data entered to list (drop-down control) | Excel Programming | |||
| how do I make drop-down list select based on 1st letter entered? | Excel Discussion (Misc queries) | |||
| have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
Threaded Mode
