I need two "linked" columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SSgt Aaron, USMC - 18 Mar 2006 13:30 GMT

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"

Reply to this Message

RagDyeR - 18 Mar 2006 22:26 GMT

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

Signature

HTH,

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

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"

Reply to this Message

SSgt Aaron, USMC - 18 Mar 2006 23:07 GMT

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

> What you're looking for are 'Dependent Lists' which are explained at Debra
> Dalgleish's web page at this link:
[quoted text clipped - 9 lines]
> 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"

Reply to this Message

RagDyeR - 19 Mar 2006 00:19 GMT

Thanks for the feed-back.

Signature

HTH,

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

<SSgt Aaron>; "USMC" <SSgtAaronUSMC@discussions.microsoft.com> wrote in
message news:04E95311-49C3-485D-84A7-FFE536C4A48A@microsoft.com...
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

Reply to this Message