I'm wanting to present the EU with a way to identify who referred a Client to them. If another Client did, then I want to track how many referrals that Client has sent the EU's way. Client's have the following identifiers: Name, Nickname and Client ID. All 3 are already named ranges and of the 3, Client ID is the only unique identifier. The issue at hand is, I don't expect the EU to have to remember every Client's ID. Instead, I was thinking maybe present them with a 3 column combo box.
When the EU selects the value they want, I would want the 3 parts of the combo box to map back to a worksheet, in their separate parts.
I did some googling, but couldn't find an example that walked through all of these parts.
Here's how this part of the worksheet is structured. *I did remove some unimpacted columns.
[TABLE="class: grid, width: 750"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Client ID[/TD]
[TD]Name[/TD]
[TD]Nickname[/TD]
[TD]Referral Category[/TD]
[TD]Referred By ID[/TD]
[TD]Referred By Name[/TD]
[/TR]
[TR]
[TD]TJ1[/TD]
[TD]Tom Jones Sr.[/TD]
[TD]Tommy[/TD]
[TD]Friend[/TD]
[TD][/TD]
[TD]Moonshine[/TD]
[/TR]
[TR]
[TD]ND2[/TD]
[TD]Nancy Drew[/TD]
[TD]Neener[/TD]
[TD]Client[/TD]
[TD]TJ1[/TD]
[TD]Tommy[/TD]
[/TR]
</tbody>[/TABLE]
An example of what I'm looking for is, when Client "ND2" was added. I would have wanted a combobox to present
TJ1 Tom Jones Sr. Tommy
Is there a better route to accomplish my goal? If so, please advise. If not, can someone offer some guidance on how to solve this?
When the EU selects the value they want, I would want the 3 parts of the combo box to map back to a worksheet, in their separate parts.
I did some googling, but couldn't find an example that walked through all of these parts.
Here's how this part of the worksheet is structured. *I did remove some unimpacted columns.
[TABLE="class: grid, width: 750"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Client ID[/TD]
[TD]Name[/TD]
[TD]Nickname[/TD]
[TD]Referral Category[/TD]
[TD]Referred By ID[/TD]
[TD]Referred By Name[/TD]
[/TR]
[TR]
[TD]TJ1[/TD]
[TD]Tom Jones Sr.[/TD]
[TD]Tommy[/TD]
[TD]Friend[/TD]
[TD][/TD]
[TD]Moonshine[/TD]
[/TR]
[TR]
[TD]ND2[/TD]
[TD]Nancy Drew[/TD]
[TD]Neener[/TD]
[TD]Client[/TD]
[TD]TJ1[/TD]
[TD]Tommy[/TD]
[/TR]
</tbody>[/TABLE]
An example of what I'm looking for is, when Client "ND2" was added. I would have wanted a combobox to present
TJ1 Tom Jones Sr. Tommy
Is there a better route to accomplish my goal? If so, please advise. If not, can someone offer some guidance on how to solve this?