You're AMAZING!!! Thank you so much for your help. I never would've figured
that out myself.



"Max" wrote:

One possibility ..

A sample construct is available at:
http://savefile.com/files/414328
Interactive Summary.xls

Assuming identically structured source sheets
named as eg: Doc1, Doc2, Doc3, etc, viz:

In sheet: Doc1
Date Biopsies Patients
01-Dec-06 5 12
02-Dec-06 1 11
03-Dec-06 3 14
etc

In sheet: Doc2
Date Biopsies Patients
01-Dec-06 4 12
02-Dec-06 1 14
03-Dec-06 2 9
etc, and so on

In sheet: Summary,

Create a data validation droplist in A2 to allow easy selection of the
summary field of interest, eg: Biopsies, Patients

Click Data Validation
Allow: List
Source: Biopsies, Patients
Click OK

Then list the sheetnames (doctor's names) in B2 across. Ensure these names
are consistent with the names entered on the actual tabs. List the dates in
A3 down

Put in B3:
=IF(OR($A$2="",$A3="",B$2=""),"",SUMIF(INDIRECT("' "&B$2&"'!A:A"),$A3,OFFSET(INDIRECT("'"&B$2&"'!A:A" ),,MATCH($A$2,INDIRECT("'"&B$2&"'!1:1"),0)-1)))
Copy B3 across / fill down as far as required to populate the summary table.
The table will return the required results for the selected field (in A2)
from all the source sheets.

For a neater look, suppress the display of extraneous zeros in the sheet via
clicking: Tools Options View tab Uncheck "Zero values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"panzram" wrote:
Does anyone know a way to create an interactive/revolving formula that would
automatically refresh daily?

Here's what I'm trying to do:

I have a list of Doctors, I need to track their daily number of biopsies and
patients seen. I need to create a simple daily summary for my director that
will
report the pertinent numbers but refresh automatically the next day when new
numbers are entered in another worksheet (within the same workbook). Make
sense?

I appreciate any and all help.