Hi,
I want to create a list of items to chose from within a
cell, so that when you select the item you want, the cell
is populated and then the drop down goes to the next
cell. This is NOT a combo or list box based on what I've
been looking at. I want the cell to actually populate and
I want the selector to reside within each cell in the
column. I've seen this before at the last company I
worked at, but did not find out how they did it and am
kicking myself for it.

Thanks,
Carrie

I think what your looking for is something like a lookup.

Example in columns A & B rows 1 through 8
A 1
B 2
C 3
D 4
E 5
F 6
G 7
H 8

in cell A10 a dropdown populated by A1:A8
in cell A11 =VLOOKUP(A10,A1:B8,2,FALSE)

will find the number next to the letter picked from the list

Dan E

"Jamison Smith" <(E-Mail Removed)> wrote in message
news:017f01c35534$e4a513f0$(E-Mail Removed)...
> Dan,
>
> I had a similar situation and the data-->validation was
> perfect. As a follow up, can you use a similar process to
> set up a second column that automatically populates based
> on your selection from your frist drop-down box?
>
> Example, if I select "A" from my data validation drop down
> box in cell "A10", I automatically get populated "1" in
> Cell "A11"
>
> Thanks,
> Jamison
>
>
> >-----Original Message-----
> >Carrie,
> >
> >Have a look at the menu item
> >"Data" -> "Validation"
> >
> >Allows the in cell dropdown, just choose list from
> the "Allow" field of the
> >Validation criteria under the settings tab. You can
> populate the source
> >using
> >" a, b, c, d" or selecting a range.
> >
> >Dan E
> >
> >"Carrie" <(E-Mail Removed)> wrote in message
> >news:022301c35530$c9775ce0$(E-Mail Removed)...
> >> Hi,
> >> I want to create a list of items to chose from within a
> >> cell, so that when you select the item you want, the
> cell
> >> is populated and then the drop down goes to the next
> >> cell. This is NOT a combo or list box based on what
> I've
> >> been looking at. I want the cell to actually populate
> and
> >> I want the selector to reside within each cell in the
> >> column. I've seen this before at the last company I
> >> worked at, but did not find out how they did it and am
> >> kicking myself for it.
> >>
> >> Thanks,
> >> Carrie
> >
> >
> >.
> >

Hi Dan,

I'm trying to set it up the way you said and for some
reason the drop down is not activating. The only thing it
is doing is not allowing me to type what is not on the
list. I made sure the in-cell drop down was checked in
the settings tab under data validation. What else do I
need to turn on? An add-in?

Thanks again for your help.
C


>-----Original Message-----
>Carrie,
>
>Have a look at the menu item
>"Data" -> "Validation"
>
>Allows the in cell dropdown, just choose list from
the "Allow" field of the
>Validation criteria under the settings tab. You can
populate the source
>using
>" a, b, c, d" or selecting a range.
>
>Dan E
>
>"Carrie" <(E-Mail Removed)> wrote in message
>news:022301c35530$c9775ce0$(E-Mail Removed)...
>> Hi,
>> I want to create a list of items to chose from within a
>> cell, so that when you select the item you want, the
cell
>> is populated and then the drop down goes to the next
>> cell. This is NOT a combo or list box based on what
I've
>> been looking at. I want the cell to actually populate
and
>> I want the selector to reside within each cell in the
>> column. I've seen this before at the last company I
>> worked at, but did not find out how they did it and am
>> kicking myself for it.
>>
>> Thanks,
>> Carrie
>
>
>.
>

Carrie,

I can't see why it wouldn't work? As far as I know an add-in is not needed?
As long as it's set to list and the in cell dropdown is check it should
work?

Dan E

"Carrie" <(E-Mail Removed)> wrote in message
news:357401c35546$60e5cb10$(E-Mail Removed)...
> Hi Dan,
>
> I'm trying to set it up the way you said and for some
> reason the drop down is not activating. The only thing it
> is doing is not allowing me to type what is not on the
> list. I made sure the in-cell drop down was checked in
> the settings tab under data validation. What else do I
> need to turn on? An add-in?
>
> Thanks again for your help.
> C
>
>
> >-----Original Message-----
> >Carrie,
> >
> >Have a look at the menu item
> >"Data" -> "Validation"
> >
> >Allows the in cell dropdown, just choose list from
> the "Allow" field of the
> >Validation criteria under the settings tab. You can
> populate the source
> >using
> >" a, b, c, d" or selecting a range.
> >
> >Dan E
> >
> >"Carrie" <(E-Mail Removed)> wrote in message
> >news:022301c35530$c9775ce0$(E-Mail Removed)...
> >> Hi,
> >> I want to create a list of items to chose from within a
> >> cell, so that when you select the item you want, the
> cell
> >> is populated and then the drop down goes to the next
> >> cell. This is NOT a combo or list box based on what
> I've
> >> been looking at. I want the cell to actually populate
> and
> >> I want the selector to reside within each cell in the
> >> column. I've seen this before at the last company I
> >> worked at, but did not find out how they did it and am
> >> kicking myself for it.
> >>
> >> Thanks,
> >> Carrie
> >
> >
> >.
> >

Carrie

I don't see a reference to an Excel version in your post.

With Excel 97 there was a bug in the DV.

If your DV cell is above the "freeze" line and you have Window>Freeze Panes
enabled the Arrow will not be shown.

Gord Dibben Excel MVP - XL97 SR2 & XL2002


On Mon, 28 Jul 2003 13:25:25 -0700, "Carrie" <(E-Mail Removed)>
wrote:

>Hi Dan,
>
>I'm trying to set it up the way you said and for some
>reason the drop down is not activating. The only thing it
>is doing is not allowing me to type what is not on the
>list. I made sure the in-cell drop down was checked in
>the settings tab under data validation. What else do I
>need to turn on? An add-in?
>
>Thanks again for your help.
>C
>
>
>>-----Original Message-----
>>Carrie,
>>
>>Have a look at the menu item
>>"Data" -> "Validation"
>>
>>Allows the in cell dropdown, just choose list from
>the "Allow" field of the
>>Validation criteria under the settings tab. You can
>populate the source
>>using
>>" a, b, c, d" or selecting a range.
>>
>>Dan E
>>
>>"Carrie" <(E-Mail Removed)> wrote in message
>>news:022301c35530$c9775ce0$(E-Mail Removed)...
>>> Hi,
>>> I want to create a list of items to chose from within a
>>> cell, so that when you select the item you want, the
>cell
>>> is populated and then the drop down goes to the next
>>> cell. This is NOT a combo or list box based on what
>I've
>>> been looking at. I want the cell to actually populate
>and
>>> I want the selector to reside within each cell in the
>>> column. I've seen this before at the last company I
>>> worked at, but did not find out how they did it and am
>>> kicking myself for it.
>>>
>>> Thanks,
>>> Carrie
>>
>>
>>.
>>