Data Validation
 

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

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

Data Validation
 

I posted it in both, since I was not sure where I would find someone with an
answer. I do not care where I receive an answer, as long as I get one.

Thanks

Don

"Don Guillett" wrote:

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

Data Validation
 

The point is that we request that you only post in ONE group. We DO care,

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Donald Dudar" wrote in message
...
I posted it in both, since I was not sure where I would find someone with
an
answer. I do not care where I receive an answer, as long as I get one.

Thanks

Don

"Don Guillett" wrote:

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

Data Validation
 

I posted it in both, since I was not sure where I would find someone with
an
answer. I do not care where I receive an answer, as long as I get one.

For your future consideration...

From a post by Jeff Johnson:

"You have posted this question individually to multiple groups.
This is called Multiposting and it's BAD. Replies made in one
group will not be visible in the other groups, which may cause
multiple people to respond to your question with the same answer
because they didn't know someone else had already done it. This
is a waste of time.

If you MUST post your message to multiple groups, post a single
message and select all the groups (or type their names manually
in the Newsgroups field, separated by commas) in which you want
it to be seen. This is called Crossposting and when used properly
it is GOOD."

Some additional comment previously posted by me:

"You may not see this as a problem, but those of us who volunteer
answering questions on newsgroups do see it as a problem. You can't
imagine how annoying it is for a volunteer to read a question,
research background material, test sample code and then formulate
and post an answer to the original question only to go to another
newsgroup and find the question posted and ALREADY answered over
there. On top of that, if you cross-post your question, all of the
readers in all the newsgroups it is cross-posted to see both the
original question and all of the answers given to it. This is
beneficial to you because then we can add additional material to,
add clarification to, as well as add additional examples to an
answer you have received previously... that means you end up with
a more complete solution to your problem. This is a win-win
situation for all of us."

Rick

Data Validation
 

My apologies if I sounded glib; that was not my intent. I was simply trying
to reflect that it did not matter to me where a response originated.

And, I was not aware of any protocol that reuiqred posting only in one group.

I will be better informed in the future.

Don

"Don Guillett" wrote:


The point is that we request that you only post in ONE group. We DO care,

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Donald Dudar" wrote in message
...
I posted it in both, since I was not sure where I would find someone with
an
answer. I do not care where I receive an answer, as long as I get one.

Thanks

Don

"Don Guillett" wrote:

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

Data Validation
 

OK,
I get the point, although, as I have just reposnded to Don Guillet, I was
not aware of this posting protocol. Nor was I aware that I could post to two
groups. The format seemed to require selecting only one group.

So, thanks for the message, and again, as I iondicated to Rick, I will know
better in future.

Don

"Rick Rothstein (MVP - VB)" wrote:

I posted it in both, since I was not sure where I would find someone with
an
answer. I do not care where I receive an answer, as long as I get one.

For your future consideration...

From a post by Jeff Johnson:

"You have posted this question individually to multiple groups.
This is called Multiposting and it's BAD. Replies made in one
group will not be visible in the other groups, which may cause
multiple people to respond to your question with the same answer
because they didn't know someone else had already done it. This
is a waste of time.

If you MUST post your message to multiple groups, post a single
message and select all the groups (or type their names manually
in the Newsgroups field, separated by commas) in which you want
it to be seen. This is called Crossposting and when used properly
it is GOOD."

Some additional comment previously posted by me:

"You may not see this as a problem, but those of us who volunteer
answering questions on newsgroups do see it as a problem. You can't
imagine how annoying it is for a volunteer to read a question,
research background material, test sample code and then formulate
and post an answer to the original question only to go to another
newsgroup and find the question posted and ALREADY answered over
there. On top of that, if you cross-post your question, all of the
readers in all the newsgroups it is cross-posted to see both the
original question and all of the answers given to it. This is
beneficial to you because then we can add additional material to,
add clarification to, as well as add additional examples to an
answer you have received previously... that means you end up with
a more complete solution to your problem. This is a win-win
situation for all of us."

Rick