I need two "linked" columns
 

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"

I need two "linked" columns
 

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"

I need two "linked" columns
 

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" wrote:

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"

I need two "linked" columns
 

Thanks for the feed-back.
--

HTH,

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

<SSgt Aaron; "USMC" wrote in
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.

"RagDyeR" wrote:

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"