Here's what I'm looking to do...
I have a list of 2500+/- Employees.
All employees have to go through specific training.
*BUT* the location for this training can change. Right now, there are 88 different PHYSICAL locations, on a different tab than the one the employees are on.
Piece of cake, right? Data Validation, List, enter the tab/range, select the location in column AI, no problem.
I've just been tasked to create an alternate list of locations, which would all be "Virtual"... 128 of them (Separate Conference Lines).
How can I make the validation list be based on whether the location will be Physical or Virtual?
IE: If the training type will be "Physical" (Cell AD2 - N2501, Drop-Down to select "Physical" or "Virtual" (A row for each employee)),
the data validation list has the drop-down for the 88 Physical locations, which will be in Column "AI", row 2 - 2501.
If the training type will be "Virtual" (Cell N2 - AD2501, Drop-Down to select "Physical" or "Virtual" (A row for each employee)),
the data validation list has the drop-down for the 128 Virtual locations, which will be in Column "AI", row 2 - 2501.
Is this possible, withOUT using any Macros? The file has to be loaded onto the OneDrive in Outlook, which does not support Macros.
I have a list of 2500+/- Employees.
All employees have to go through specific training.
*BUT* the location for this training can change. Right now, there are 88 different PHYSICAL locations, on a different tab than the one the employees are on.
Piece of cake, right? Data Validation, List, enter the tab/range, select the location in column AI, no problem.
I've just been tasked to create an alternate list of locations, which would all be "Virtual"... 128 of them (Separate Conference Lines).
How can I make the validation list be based on whether the location will be Physical or Virtual?
IE: If the training type will be "Physical" (Cell AD2 - N2501, Drop-Down to select "Physical" or "Virtual" (A row for each employee)),
the data validation list has the drop-down for the 88 Physical locations, which will be in Column "AI", row 2 - 2501.
If the training type will be "Virtual" (Cell N2 - AD2501, Drop-Down to select "Physical" or "Virtual" (A row for each employee)),
the data validation list has the drop-down for the 128 Virtual locations, which will be in Column "AI", row 2 - 2501.
Is this possible, withOUT using any Macros? The file has to be loaded onto the OneDrive in Outlook, which does not support Macros.