Extracting data to another sheet using multiple criteria

[Dan]

I use an ongoing daily transaction list for cash collections. It has 3
columns "Date of receipt", "customer name" & "amount". I want each customer
to have their own sheet that pulls their data from the daily transaction
list. To easily print customer statements, I would like to have the
transaction history for a specific customer show up on their sheet based on
a date range I choose by typing in the begin and end date in 2 adjacent
cells. Is this possible? If so, I will yell for joy in my office.

 

[Billy Liddel]

Not exactly what you asked for but try this:

G1 = Start Date
G2 = End Date

F4 = Customer
G4 = Amount

in F5 start your list of Customers Names

In G5 copy the following formula

=SUMPRODUCT(--($B$2:$B$5000=F5),($A$2:$A$5000>=$G$1)*($C$2:$C$5000))-SUMPRODUCT(--($B$2:$B$5000=F5),($A$2:$A$5000>$G$2)*($C$2:$C$5000))

Be careful of wrapping, perhaps copy the fomula into Notepad then copy into
Excel

Copy formula own as required after changing range if more rows than 5000 in
data.

Peter