Text seacrh

[jlove916]

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]

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 here:

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

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

 

[jlove916]

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