Parsing rows in one worksheet to generate one or several rows in another worksheet?

[svliegen]

Hi,

Does anyone have any suggestion how to parse rows in one worksheet to generate one or several rows in another worksheet?

The first worksheet contains one column with a NAME plus several colums which are marked YES or NO.
For each YES I need to generate a row that lists the NAME plus the name of the column (e.g. B).

Example:

Name	A	B	C	D	E
Jones	YES	NO	NO	YES	YES
Baker	NO	YES	NO	NO	NO

This should populate a worksheet with the following rows:

Jones	A
Jones	D
Jones	E
Baker	B

Could anyone please tell me how to tackle this? It's been 15 years since I worked with VBA, so a bit of sample code would be absolutely great!

[Mumps1]

Try:

Please Login or Register  to view this content.

[svliegen]

Wow, that was fast. Thank you Mumps1, I've got it working now. Just curious, turning off the screenupdating, is that for speed or are there other reasons to do this?

regards,

svliegen

[Mumps1]

It speeds things up and prevents screen flicker.