Thanks!! I changed my range names to the way you showed it and it is working
now. Thanks so much!!!

"TomPl" wrote:

Yup, that worked based on the assumption that there is a date in column A
without any skipped rows. I think this would be more solid logic if you
could use:

PHYNO =all07_08!$F$2:$F65535
SURGDT =all07_08!$A$2:$A65535
TYPE =all07_08!$C$2:$C65535


I hope that helps.