Summary Worksheet totals

H

Hank

Each one of my worksheets contain payment records for only one person. They
are set up:
A FName
B LName
C DatePaid
D AmtPaid

The tab names on each worksheet are the person's name (ie Bill, Sally, Jim,
etc).

I want to use a summary workwheet to list and total all payments made
between two dates for a deposit record.

I would like to use a date picker to pick a start date and end date. Then
have the following infromation from each worksheet listed on the summary
worksheet ONLY IF payments were made during the time picked. Somewhere on
the summary worksheet I would like to include the Start Date and End Date.

A Fname
B Lname
C AmtPaid

How do I do this?


Thanks
Hank
 

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

Populate Deposit Record from another worksheet 4
Macro will copy formula instead of value 6
Copying a Range from Multiple Worksheets 4
Generate Subtotal Summary from Sheet1 into Sheet2 16
Summary Tab for Workbook 1
Formula: Counting Cells on Different Worksheets 3
autofilter master copy data to worksheet 1
VBA - exporting serial letters to single documents 0

Top