how do I compile data entered using a drop down list

G

Guest

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.
 
G

Guest

Maybe you should look into the Pivot Table capabilities. There is an on line
tutorial through the help facility for creating and using them.
 
G

Guest

That can certainly give me the information I need, but the format is not one
which is useful to me. I'm also trying to make the sheet automatically updat
whenever the data changes. Any other ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
Data Validation drop down list query 3
Drop Down List Format 2
Limit data entered to list (drop-down control) 3
drop down list accessed by typing the first few letters 4
Data Validation Drop Down Using VBA? 1
Excel Excel: How do I put a formula in a drop down list 11
Set Column choice to a variable from a Drop Down 4

Top