Conditional drop down list

[Closed]
Report
Posts
1
Registration date
Tuesday September 25, 2012
Status
Member
Last seen
September 25, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm creating a spreadsheet that will allow workers to fill in their time and activity. This will be imported into MYOB.

I need to have a drop down list from which the clients are selected from. However the client list is three fileds:
* Emp. Co./Last Name
* Emp. First Name
* Job

I want the drop down list to initially be the "Emp. Co./Last Name" then populate the next two columns with "Emp. First Name" and "Job".

I am able to make these conditional, but the employee has to select each column. It would be great if there is only one option that the cells could be populated automatically.

Your help would be greatly appreciated.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768