The status will be input in A1, eg: term
The input in A1 must, of course, match exactly (except for case) with what
you actually have in the status DV col in Sheet1's col B. If you have it as
"Terminate", then input the same text in A1. And if you change the input in
A1 to: Retain, it'll return the result lines for "Retain" cases. Great
flexibility there. Instead of inputting, you could also just paste the same
status DV into A1.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---