Question: You want to set up Data Validation to provide an in - cell drop down that contains a list of accounts. Assume you have a
You want to set up Data Validation to provide an incell drop down that contains a list of accounts. Assume you have a list of accounts in a Table named tblaccounts. You also have a named reference ddaccounts that refers to tblaccounts. In the Data Validation dialog box, on the Settings tab, you would allow a List, and then use which value in the Source field:
Question Select one:
a
tblaccounts
b
ddaccounts
c
tblaccounts
d
ddaccounts
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
