Hi
I got list in one table which contains three columns (Customer, Product and Type). On the other sheet I got drop down list.
I am looking for a macro through which each row data populate in drop down list one by one. Like S.No.1 will populate in dropdown list then S.No. 2 will populate and then next until end of the table. Could anyone help please?
<tbody>
</tbody>
Appreciate your help.
Kind Regards
Arun
I got list in one table which contains three columns (Customer, Product and Type). On the other sheet I got drop down list.
I am looking for a macro through which each row data populate in drop down list one by one. Like S.No.1 will populate in dropdown list then S.No. 2 will populate and then next until end of the table. Could anyone help please?
List | ||||||
S.No. | Customer | Product | Type | Description | Drop down list | |
1 | A | Apple | Medium | Customer | A | |
2 | A | Banana | Large | Product | Apple | |
3 | B | Orange | Small | Type | Medium | |
4 | B | Pears | Small | |||
5 | D | Fish | Small | |||
6 | E | Crab | Medium | |||
7 | G | Chicken | Medium |
<tbody>
</tbody>
Appreciate your help.
Kind Regards
Arun