I need two "linked" columns

[Guest]

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"

 

[RagDyeR]

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!
=====================================================

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"

 

[Guest]

Thank you very much, I was beginning to wonder if I could even do it. It
seems so easy just looking at her website.

 

[RagDyeR]

Thanks for the feed-back.
--

HTH,

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

message Thank you very much, I was beginning to wonder if I could even do it. It
seems so easy just looking at her website.