Hi,

I have database consist of 5 columns. Employee Name, Patient Name, Agency,
Date Service, Date Entered. I have been updating log of employee visit to
patient for my payroll and billing.

Until now, I was copying data from main log to new worksheet falling in
particular date range and run Pivot Table for payroll and billing (I have to
provide detail breakdown of patient name and visit day).

Is there any way I can run pivot table for date range in column 5 (Date
Enter) without copying related data to new worksheet. Is there any way I can
have some kind of macro that pick up date value between defined in some cell
(lets say F1 & G1) in main worksheet.

I am fairly new to macro and don't know how to write code.

Thanks everyone for taking time to read and response.

TD