excel tables

mme1

New Member
Joined
Nov 22, 2005
Messages
3
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.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, mme1
Welcome to the Board !!!!!

this looks like a "shrinking" validation-list
but before responding in detail I would like to see what you're exactly trying to do

please display some tables you want to use with a little more exaplanation
(not to many "words" but easy to understand examples)

use Colo's HTML Maker utility for displaying your Excel Worksheet on the board

On the "Excel Questions" main page there is a link to HTML Maker FAQ. You'll find out how to post correctly.
On the main page of the Forum there is a link to a Test here forum and a link to About this Board - to ask questions about HTLMMaker ...
please take your time to test and read carefully the FAQ !!

kind regards,
Erik
 

mme1

New Member
Joined
Nov 22, 2005
Messages
3
NAMEWeek1 Week2 Week3 Week4 Week5 Week6 Week7 Week8

Jim Buffalo Indianapolis St.Louis Miami New York Seattle Houston Buffalo
Dan
Mike
Bill
Rachel
George

What I want to do is in this sheet is allow the user to select cities from the PLACES worksheet (almost as if it were it's own table) so I can be sure that the city selections are consistent.

But the catch is the person selecting the cities can't select the same city twice. I need to be flagged if they do So that in the example above Jim selected Buffalo in Week 1 and in Week 8. I need to be flagged that Jim
selected Buffalo again in Week 8.


I'm just not sure how to allow the user to select from a pre-defined list of in this case cities and then compare each week with the week or weeks before it to see if they duplicated a city?
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
I'm quite sure to have a very good solution, but as said I need to SEE your thing: thousand words cannot replace some clear tables

see my previous post
but before responding in detail I would like to see what you're exactly trying to do
plus you received all info and links how to do it
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,022
Messages
5,834,994
Members
430,330
Latest member
Syed Yasir Hannan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top