Just a couple more questions.

As I only have 7 differnet sheets, I created 5 dummy sheets for the time
being to utilize the formulas as-is. I wsa not clear on how to
shortenlegthen each formula to accomodate less/more data sheets. For the
columns g-p and r-ae I have tried to modify, but I start loosing data.

Also, if I only have 2 header rows, do the numberical "5's" in the formulas
change to "2's"?

Thanks again.

John


"Max" wrote:

Am I limited to 125 entries?

No, that's as-is. It can be adapted to suit

Also, as data is entered into each of the attached sheets,
will the filtered list in the 'summ' sheet automatically update?

Yes, it should but you'd first need to change the book's calc mode from
Manual to Auto (Click Tools Options Calculation tab Check "Automatic"
OK)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote in message
...
Thanks for the input. I will give it a try. Am I limited to 125 entries?
Also, as data is entered into each of the attached sheets, will the
filtered
list in the 'summ' sheet automatically update?
--
Thanks

John