maybe by sumproduct or some other way with text.
the pivot table was now set as per suggestion. Looks neat. I may just post
for another question on how to automate printing of selected *only* employees
record...considering that the page field cannot accept a formula - other than
a typical dropdown list.
thanks a lot and more power,
driller
--
*****
birds of the same feather flock together..
|