I am looking at a table. It is almost like a 2X2 array.
I want to find out if a person is trained in an area(Excel). The tabl
has training (Rows), and names (Columns). The search would be for sa
"Current". Then output in the following format on a new worksheet.

Status
(Search type)
Training Name(i.e. Excel spreedsheets)

John Smith
Mike Jones
Scott Verhoef
ect.



I could adapt the code to search for the following Current
Update(6months), Update(3months), Update(1month), Expired, an
Untrained.
I know I am going to have to use a loop and some type of filter.

I am still looking for the answer. Just thought some one might hav
done this

--
Message posted from http://www.ExcelForum.com