I would like to add a VBA dropdown list in the cell right below "Name". If the cell to the right (named cell: 'RVStatus') says "Active" then I want the dropdown list to reference named range: EmpActiveAlpha, but if the cell says "In Active" - then I would like the dropdown list to reference named range: EmpInActiveAlpha.
Thank you in advance for your help!
1) From the Data tab on the ribbon, select "Data Validation"
2) Allow "list"
3) Enter this formula in Source...
=IF(RVStatus="Active", EmpActiveAlpha, IF(RVStatus="In Active", EmpInActiveAlpha, ""))
4) Click OK.