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.

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$50 00))-SUMPRODUCT(--($B$2:$B$5000=F5),($A$2:$A$5000$G$2)*($C$2:$C$500 0))

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

"Dan" wrote:

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.