Writing VBA macro for generating missing variable

[ryan8200]

Hello members,

I would like to write VBA macro for listing the missing variables as per below.

Among candidates A, B C, D and E. I would like to list down the missing variables (Hobbies), accompanied by the candidates name. ​

Hobbies	A	B	C	D	E
Swimming	Y	Y	Y	N	N
Tennis	N	Y	Y	Y	N
Badminton	N	N	Y	Y	Y
Volleyball	Y	N	N	Y	N

<tbody>
</tbody>

The expected outcome will be looked like as below:

Hobbies	Candidate
Tennis	A
Badminton	A
Badminton	B
Volleyball	B
Volleyball​ <strike></strike>	C
Swimming	D
Swimming	E
Tennis	E
Volleyball	E

<tbody>
</tbody>

Your kind assistance is greatly appreciated.

Many thanks.

Regards,
Ryan

 

[kweaver]

If you modified the existing macro, post your version now and I'll show you how to place the headers on.

Basically, from my original macro, you want to use something like:

Cells(7, 1) = "Hobbies"
Cells(7, 2) = "Candidate"

Always happy to help!

Kevin

 

[ryan8200]

If you modified the existing macro, post your version now and I'll show you how to place the headers on.

Basically, from my original macro, you want to use something like:

Cells(7, 1) = "Hobbies"
Cells(7, 2) = "Candidate"

Always happy to help!

Kevin

Thanks for the help. How to amend the code so that the output will be displayed at new worksheet instead of existing worksheet