I have a worksheet of names down column 1 and in row 1 I have weeks going out to say week 10.
I have another worksheet that lists in column 1 ID's in column two names of places.
What I want to do in worksheet one is be able to pick from worksheet two names of places for each name for each week. HOWEVER, from week to week no user can pick the same name from a previous week.
How can I accomplish this in excel?
SO, I pick Buffalo for week1 in week2 and on I cannot pick buffalo again. If I do I want to be warned that I already picked that place and what week I picked it in.
I have another worksheet that lists in column 1 ID's in column two names of places.
What I want to do in worksheet one is be able to pick from worksheet two names of places for each name for each week. HOWEVER, from week to week no user can pick the same name from a previous week.
How can I accomplish this in excel?
SO, I pick Buffalo for week1 in week2 and on I cannot pick buffalo again. If I do I want to be warned that I already picked that place and what week I picked it in.