ok maybe i should tell you what exactly it is for... i'm creating a time
sheet for field opperators so they can tell us what they did, for how long,
and on what. ie sam worked 3 hours on warranty(selection from first list) i
want it to prompt him with was it manufacturing or vendor (selection from
second list) then prompt for type of work done (selection from third list)

i used data validation and am not familiar(i don't think) with controls or
comboboxes meaning if i have used them it's been a really long time since. i
asked one of the IT guys and he said access would allow me to do that but
they would like it in excel.

and i thought i knew this program!!!!!
"KR" wrote:

You can set up two separate drop down lists that are linked, if you use the
actual controls and not just the within-cell validation. Now that I think
about it, you could probably use the in-cell validation too, although I'd
have to think about the details if you had a bunch of rows where you wanted
to do this selection.

If you set a cell to equal your first combobox value (or first data
validation cell, etc.), then use that as a source for vlookup which could
return a column letter for your target sub-list. Maybe put this value in
your third column, so that each of your sub-list selection cells would be
able to use it's own pointer to the appropriate sublist. Then set your
second combobox or data validation cell to a named range that picks your
sub-list using the "indirect" worksheet function.

That's just off the top of my head, and the details really will depend on
whether you are using data validation or comboboxes (and maybe whether you
are using comboboxes on the worksheet itself, or on a userform)



"Sburlingham" wrote in message
...
I have a problem, i created a drop down list of jobs that could have been
preformed i need to create another list for each of those jobs to be more
specific with what exactly was preformed i had this great idea that maybe
if
i picked for example warranty work that another list would drop down and
let
me pick manufacturing or vendor then another list would drop down and i
could
pick what kinda manufact. or vendor warranty it was. this may not be
possible
though it would be a great thing to implement in the future i need a way
that
is user friendly to detail what work was done. any ideas?