sharma9187
New Member
- Joined
- Jul 11, 2012
- Messages
- 8
Hello,
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Salesperson[/TD]
[TD]Customer Name[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Customer1[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Customer2[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Customer3[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD]Customer4[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD]Customer5[/TD]
[/TR]
</tbody>[/TABLE]
I have the above master data and I need to use data validation to get the list of customers in a drop down associated for a particular sales person. Assume I select Person A in A1 I should get the list of customers associated with Person A in B1 and that should be a drop down list using data validation.
Could anyone please help on formulating this. I have tried many options but failed.
Thanks
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Salesperson[/TD]
[TD]Customer Name[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Customer1[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Customer2[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Customer3[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD]Customer4[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD]Customer5[/TD]
[/TR]
</tbody>[/TABLE]
I have the above master data and I need to use data validation to get the list of customers in a drop down associated for a particular sales person. Assume I select Person A in A1 I should get the list of customers associated with Person A in B1 and that should be a drop down list using data validation.
Could anyone please help on formulating this. I have tried many options but failed.
Thanks