staticbob
Well-known Member
- Joined
- Oct 7, 2003
- Messages
- 1,079
Hi,
I would like a cell to have an entry if a name is one of 10 in a list, else use the data validation list.
Example. If the name entered in A1 is one of the IT team, then the office is Central - IT Team. Otherwise, select from a drop-down list of 30 other offices.
Cheers
Bob
I would like a cell to have an entry if a name is one of 10 in a list, else use the data validation list.
Example. If the name entered in A1 is one of the IT team, then the office is Central - IT Team. Otherwise, select from a drop-down list of 30 other offices.
Cheers
Bob