Herb
You can do that with VBA programming but an obvious problem is how do you
get the first list back? That too can be solved with VBA but you would have
to decide how you want that done. For instance:
When the file is opened or
When that sheet is activated or
When you click on some specific button or
Etc.
Post back if you want to pursue this further. HTH Otto

"Herb" wrote in message
...
I have a list of categories and a secondary list of items associated with
each choice on the category list. I would like to be able to select a
category and then a selection from the secondary or dependent list but
have
only that value show up in the column. There is only one column and I
don't
want to display the category. All the examples I have seen would place the
category selection in column 1 and the dependent choice in column 2.
Any help would be much appreciated!
--
Thanks,
Herb