Thread
:
Data Validation
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Data Validation
Do you want an answer here or in the .misc group
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Donald Dudar" wrote in message
...
I am trying to build a worksheet to help create schedule assignments.
Columns show the date, and the people being assigned are list in Column A.
I
have set up data validation, so that people can only be assigned to
specific
tasks, found in the list source. However, I want to ensure that only one
person is assigned to any one task in the list. Later, I will also want
to
set up a protocol to make sure that someone is in fact asisgned to every
task.
Any suggesdtions on the best way to achieve this?
Thanks
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett