What you're looking for are 'Dependent Lists' which are explained at Debra
Dalgleish's web page at this link:

http://www.contextures.com/xlDataVal02.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

<SSgt Aaron; "USMC" <SSgt Aaron, wrote in
message ...
I have made a budget/expense tracker for personal use, that I would like to
do something with that I cannot figure out how to do. The expense input
sheets contain two columns that add up where my money went. I would like to
turn them into drop lists, but I want the available choices in the second
columns depend on the choice that was made in the first column. That way,
if
I choose "Car" in the first column, only options related to "Car" will be
available in the second, not things like "Books" or "Dining Out"