Thx- again Max
you now I think I finally got, but I sent you the file, to your yohoo
address, in the subject line it says from Markitos. I attached the file. Let
me know what you think. As youll see I have two sheet of info, one sheet that
put both together, and finally a reports sheet, its the only way that i can
get it to work out correct. I also tried putting both sheets in the formula
but it doesnt return any values. But the way I have it now works but it has
an extra sheet, but ill just move it the the end and lock the cells.

thanks-again-Markitos

"Max" wrote:

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