June 21, 2024


Welcome to the core

Data Validation Based on Cell Value

You can add a Data Validation list based on the value of another cell.

For this example, it uses the VBA code – Windows Username – depending on who is accessing the workbook will depend on the list of values they will be shown in the Data Validation list.
Using a simple lookup if the user is part of the “BSA” team this will show the BSA list, if not in the list, to show the “Training” list. These lists are created using “Named Ranges”.
Really simple to use and very effective!
Copyright © All rights reserved. | Newsphere by AF themes.