Hi all,
Thank you in advance for helping.
I am very new for VBA and have some data would like to transpose from column to row where it is dynamic, see below, please -
<colgroup><col style="width:58pt" span="2" width="77"> </colgroup><tbody>
</tbody>
To Make it like below
Item Whitelist Values
1 D
2 A B C D E
3 C
I have searched the forum for quite long, but only could found those transpose from row to column.
After transposed, I would like to use VBA to validate data from other range,
say, if the cell "A1" equals 2 in other range, then VBA to help to check the "white list's value" of 2, thus, the cell "B1" could be either A/B/C/D/E, mark "Value in range", else mark "Value not in range" in "C1"
As below -
A B C
2 D "
If the item is not on the list, mark "Item not found" in "C1"
A B C
4 A "Item not found"
Grateful if anyone could help, please. Thank you very much.
Thank you in advance for helping.
I am very new for VBA and have some data would like to transpose from column to row where it is dynamic, see below, please -
Item | - Value |
1 | D |
2 | A |
B | |
C | |
D | |
E | |
3 | C |
<colgroup><col style="width:58pt" span="2" width="77"> </colgroup><tbody>
</tbody>
To Make it like below
Item Whitelist Values
1 D
2 A B C D E
3 C
I have searched the forum for quite long, but only could found those transpose from row to column.
After transposed, I would like to use VBA to validate data from other range,
say, if the cell "A1" equals 2 in other range, then VBA to help to check the "white list's value" of 2, thus, the cell "B1" could be either A/B/C/D/E, mark "Value in range", else mark "Value not in range" in "C1"
As below -
A B C
2 D "
If the item is not on the list, mark "Item not found" in "C1"
A B C
4 A "Item not found"
Grateful if anyone could help, please. Thank you very much.