Easily done. See this for instructions:

http://contextures.com/xlDataVal02.html

Biff

"Eric" wrote in message
...
I am attempting to use Excel to track purchases of vehicles by make and
model. I have a list of each make of a car (ex. Ford, GMC, etc) in a pull
down list for a given cell in one column. In the adjacent column, I wish
to
make a pull down list of just the models of the specific make chosen in
the
previous column. For example, if Ford is chosen in the first column, I
want
the pull down menu to list just the ford cars in the next colum or GMC so
on
and so forth so that I do not have to go through every model. Is there any
way to possibly do this in excel?