richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 87
- Office Version
- 2016
- Platform
- Windows
How would I do this? I am not using Visual Basic.
[TABLE="width: 443"]
<tbody>[TR]
[TD="width: 590, bgcolor: transparent"]I have form and I am trying to auto populate other fields based on the selection in a combo box. I tried VLookups but they will not recognize the data in the drop down box.
I have a separate tab with all of the sales peoples name and other information.
A1:A25 Salespersons Name
B1:B25 Salespersons Telephone number
C1:C25 Sales Persons Assistants Name
What I need is a way to pull in the information based on the sales person selected
A1 Combo Box with list of sale people’s names and select one sales person’s name and the next two will auto populate with the correct information.
A2 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information
A3 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information
I am trying to auto populate other fields based on the selection in a combo box. I tried VLookups but they will not recognize the data in the drop down box.
I have a separate tab with all of the sales peoples name and other information.
A1:A25 Salespersons Name
B1:B25 Salespersons Telephone number
C1:C25 Sales Persons Assistants Name
What I need is a way to pull in the information based on the sales person selected
A1 Combo Box with list of sale people’s names and select one sales person’s name and the next two will auto populate with the correct information.
A2 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information
A3 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 443"]
<tbody>[TR]
[TD="width: 590, bgcolor: transparent"]I have form and I am trying to auto populate other fields based on the selection in a combo box. I tried VLookups but they will not recognize the data in the drop down box.
I have a separate tab with all of the sales peoples name and other information.
A1:A25 Salespersons Name
B1:B25 Salespersons Telephone number
C1:C25 Sales Persons Assistants Name
What I need is a way to pull in the information based on the sales person selected
A1 Combo Box with list of sale people’s names and select one sales person’s name and the next two will auto populate with the correct information.
A2 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information
A3 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information
I am trying to auto populate other fields based on the selection in a combo box. I tried VLookups but they will not recognize the data in the drop down box.
I have a separate tab with all of the sales peoples name and other information.
A1:A25 Salespersons Name
B1:B25 Salespersons Telephone number
C1:C25 Sales Persons Assistants Name
What I need is a way to pull in the information based on the sales person selected
A1 Combo Box with list of sale people’s names and select one sales person’s name and the next two will auto populate with the correct information.
A2 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information
A3 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information
[/TD]
[/TR]
</tbody>[/TABLE]