The suggested set-up already returns an
auto-descending sort by date in Sheet2 (the report sheet),
with the earliest (oldest) expired date on top and so on,
so I'm not sure what happened ..

Maybe you'd like to have a sample file via private email?
If so, post a "readable" email add in response here

Btw, pl don't use a lot of caps (it's kinda hard to read) ..

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Markitos" wrote in message
...
Thx Max your so good. What i ended up doing was keep all seven sheets but
i
added another and condenced all seven into one, then put the formula in
with
just changing the sheet.

YES I HAVE YET ANOTHER QUESTION!!!!!!!!!!!!!!!!YEP....
I WAS TRYING TO SORT THE REPORT PAGE BY DATE AND FAILED. WHAT IAM TRYING
TO
ACC. IS TO GET THE SHEET TO AUTO SORT BY DATE. W/ OLDEST DATE COMPARED TO
TODAY TO BE ON TOP THEN SO ON.

THX- MUCHO!, YOUR P I M P