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?
[TABLE="width: 571"]
<tbody>[TR]
[TD]List
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S.No.
[/TD]
[TD]Customer
[/TD]
[TD]Product
[/TD]
[TD]Type
[/TD]
[TD][/TD]
[TD]Description
[/TD]
[TD]Drop down list
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]A
[/TD]
[TD]Apple
[/TD]
[TD]Medium
[/TD]
[TD][/TD]
[TD]Customer
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]A
[/TD]
[TD]Banana
[/TD]
[TD]Large
[/TD]
[TD][/TD]
[TD]Product
[/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]B
[/TD]
[TD]Orange
[/TD]
[TD]Small
[/TD]
[TD][/TD]
[TD]Type
[/TD]
[TD]Medium
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]B
[/TD]
[TD]Pears
[/TD]
[TD]Small
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]D
[/TD]
[TD]Fish
[/TD]
[TD]Small
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]E
[/TD]
[TD]Crab
[/TD]
[TD]Medium
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]G
[/TD]
[TD]Chicken
[/TD]
[TD]Medium
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 571"]
<tbody>[TR]
[TD]List
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S.No.
[/TD]
[TD]Customer
[/TD]
[TD]Product
[/TD]
[TD]Type
[/TD]
[TD][/TD]
[TD]Description
[/TD]
[TD]Drop down list
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]A
[/TD]
[TD]Apple
[/TD]
[TD]Medium
[/TD]
[TD][/TD]
[TD]Customer
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]A
[/TD]
[TD]Banana
[/TD]
[TD]Large
[/TD]
[TD][/TD]
[TD]Product
[/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]B
[/TD]
[TD]Orange
[/TD]
[TD]Small
[/TD]
[TD][/TD]
[TD]Type
[/TD]
[TD]Medium
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]B
[/TD]
[TD]Pears
[/TD]
[TD]Small
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]D
[/TD]
[TD]Fish
[/TD]
[TD]Small
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]E
[/TD]
[TD]Crab
[/TD]
[TD]Medium
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]G
[/TD]
[TD]Chicken
[/TD]
[TD]Medium
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Appreciate your help.
Kind Regards
Arun