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. ​

[TABLE="width: 500"]
<tbody>[TR]
[TD]Hobbies[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Swimming[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD]N[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Tennis[/TD]
[TD]N[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Badminton[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Volleyball[/TD]
[TD]Y[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]Y[/TD]
[TD]N[/TD]
[/TR]
</tbody>[/TABLE]

The expected outcome will be looked like as below:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Hobbies [/TD]
[TD]Candidate[/TD]
[/TR]
[TR]
[TD]Tennis[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Badminton[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Badminton [/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Volleyball[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]

Volleyball​

<strike></strike>
[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Swimming[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Swimming[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Tennis[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Volleyball[/TD]
[TD]E[/TD]
[/TR]
</tbody>[/TABLE]


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