ajaysomasi
New Member
- Joined
- Mar 6, 2017
- Messages
- 25
Hi all
Appreciate if you can provide me with a VBA to undertake the below task..
I want the program to take 1 under each column and report the applicable rows for that column in the format shown after the table.. Appreciate your help..
The resulting format should be:
Subject A
Row1
Row3
Row5
Subject B
Row4
Row5
Subject C
Row1
Row2
Appreciate if you can provide me with a VBA to undertake the below task..
I want the program to take 1 under each column and report the applicable rows for that column in the format shown after the table.. Appreciate your help..
Subject A | Subject B | Subject C | |
Row1 | 1 | N | 1 |
Row2 | N | N | 1 |
Row3 | 1 | N | N |
Row4 | N | 1 | N |
Row5 | 1 | 1 | N |
The resulting format should be:
Subject A
Row1
Row3
Row5
Subject B
Row4
Row5
Subject C
Row1
Row2