Hi.
I am trying to so a loop search in excel and outputing it into a table


I have a small data group.

names . . .. . .. .. .. . . . .
training
. status status . . . . . .. .
. status
. .
. .
. .

It's not clear what you're trying to search for, or output, but perhaps
you could use an Advanced Filter. There are instructions in Excel's
help, and he

http://www.contextures.com/xladvfilter01.html

Record a macro as you manually perform a filter, then modify the code as
required.

jlove916 < wrote:
Hi.
I am trying to so a loop search in excel and outputing it into a table.


I have a small data group.

names . . .. . .. .. .. . . . .
training
status status . . . . . .. .
status
.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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