can I sum information in a list

W

WTG

I have a speadsheet (TICKETS) the has the following list from cells
A1:K1000.



ticket ticket ticket customer product amount
date time number id id



On another sheet (INVOICE) if I enter in cell a1 a starting date, and
in cell b1 a finishing date.

Can I make a drop down list that will show me a summary ofall
customers in my list of tickets, between the starting and finishing
dates?
(there may be 1000 tickets, but only 100 different customers. and the
ticket list may be for the year but I only want a certian month).
 
J

Jim Thomlinson

You can use Autofilters -> Custom to create the lists. As for a drop down
that is distinctly more difficult.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
A few questions if anyone has a moment? 0
Using Microsoft Access as a Service Ticket Write-up program 0
Creating child worksheet from parent 7
Excel Formula - If Cell contains word and select it from a list? 0
Showing two 'counts' on the same row 4
How do I set up a counter to keep track of prited copies (2 pages. 1
Copying multiple records for the same vendor 3

Top