Can anyone point me in the right direction to get some help?

I have a spreadsheet that is used to track financcial data. Currenlty you
type in the type of expense in two columns (eg: "gasoline" and "car 1" or
"phone" and "mobile #1". I have catagorised every type of expense broken down
into groups using a three part number (eg 11.14.02). Can I put a
formula/function/something in that allows me to choose off a small list in
column 1 (eg. showing "11 - Car expenses" and putting "11" in the box) which
then gives a different clist to choose off in colujmn two depending on what I
chose in column 1 (eg. showing "14 - gasoline" and putting 14 in the cell)
and the same for the third column? So what happens is you get a different
drop down list (with about 6 choices each) depending on what you chose in the
previous column.

Hi sa,

Have a look at these:
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal13.html

Regards,
KL

"sa" <(E-Mail Removed)> wrote in message
news:6E474DA8-F49B-406D-9FBB-(E-Mail Removed)...
> Can anyone point me in the right direction to get some help?
>
> I have a spreadsheet that is used to track financcial data. Currenlty you
> type in the type of expense in two columns (eg: "gasoline" and "car 1" or
> "phone" and "mobile #1". I have catagorised every type of expense broken
> down
> into groups using a three part number (eg 11.14.02). Can I put a
> formula/function/something in that allows me to choose off a small list in
> column 1 (eg. showing "11 - Car expenses" and putting "11" in the box)
> which
> then gives a different clist to choose off in colujmn two depending on
> what I
> chose in column 1 (eg. showing "14 - gasoline" and putting 14 in the cell)
> and the same for the third column? So what happens is you get a different
> drop down list (with about 6 choices each) depending on what you chose in
> the
> previous column.

See this:

http://contextures.com/xlDataVal02.html

Biff

"sa" <(E-Mail Removed)> wrote in message
news:6E474DA8-F49B-406D-9FBB-(E-Mail Removed)...
> Can anyone point me in the right direction to get some help?
>
> I have a spreadsheet that is used to track financcial data. Currenlty you
> type in the type of expense in two columns (eg: "gasoline" and "car 1" or
> "phone" and "mobile #1". I have catagorised every type of expense broken
> down
> into groups using a three part number (eg 11.14.02). Can I put a
> formula/function/something in that allows me to choose off a small list in
> column 1 (eg. showing "11 - Car expenses" and putting "11" in the box)
> which
> then gives a different clist to choose off in colujmn two depending on
> what I
> chose in column 1 (eg. showing "14 - gasoline" and putting 14 in the cell)
> and the same for the third column? So what happens is you get a different
> drop down list (with about 6 choices each) depending on what you chose in
> the
> previous column.

do a search of dependant lists

http://www.contextures.com/xlDataVal02.html
--
paul
(E-Mail Removed)
remove nospam for email addy!



"sa" wrote:

> Can anyone point me in the right direction to get some help?
>
> I have a spreadsheet that is used to track financcial data. Currenlty you
> type in the type of expense in two columns (eg: "gasoline" and "car 1" or
> "phone" and "mobile #1". I have catagorised every type of expense broken down
> into groups using a three part number (eg 11.14.02). Can I put a
> formula/function/something in that allows me to choose off a small list in
> column 1 (eg. showing "11 - Car expenses" and putting "11" in the box) which
> then gives a different clist to choose off in colujmn two depending on what I
> chose in column 1 (eg. showing "14 - gasoline" and putting 14 in the cell)
> and the same for the third column? So what happens is you get a different
> drop down list (with about 6 choices each) depending on what you chose in the
> previous column.

See Debra Dalgleish's site for instructions on creating dependent lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Sat, 8 Jul 2006 14:49:01 -0700, sa <(E-Mail Removed)> wrote:

>Can anyone point me in the right direction to get some help?
>
>I have a spreadsheet that is used to track financcial data. Currenlty you
>type in the type of expense in two columns (eg: "gasoline" and "car 1" or
>"phone" and "mobile #1". I have catagorised every type of expense broken down
>into groups using a three part number (eg 11.14.02). Can I put a
>formula/function/something in that allows me to choose off a small list in
>column 1 (eg. showing "11 - Car expenses" and putting "11" in the box) which
>then gives a different clist to choose off in colujmn two depending on what I
>chose in column 1 (eg. showing "14 - gasoline" and putting 14 in the cell)
>and the same for the third column? So what happens is you get a different
>drop down list (with about 6 choices each) depending on what you chose in the
>previous column.

Gord Dibben MS Excel MVP

Thanks. You guys are legends - definately worthy of wearing our underwear on
the outside.
Cheers, Sa

"Gord Dibben" wrote:

> See Debra Dalgleish's site for instructions on creating dependent lists.
>
> http://www.contextures.on.ca/xlDataVal02.html
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 8 Jul 2006 14:49:01 -0700, sa <(E-Mail Removed)> wrote:
>
> >Can anyone point me in the right direction to get some help?
> >
> >I have a spreadsheet that is used to track financcial data. Currenlty you
> >type in the type of expense in two columns (eg: "gasoline" and "car 1" or
> >"phone" and "mobile #1". I have catagorised every type of expense broken down
> >into groups using a three part number (eg 11.14.02). Can I put a
> >formula/function/something in that allows me to choose off a small list in
> >column 1 (eg. showing "11 - Car expenses" and putting "11" in the box) which
> >then gives a different clist to choose off in colujmn two depending on what I
> >chose in column 1 (eg. showing "14 - gasoline" and putting 14 in the cell)
> >and the same for the third column? So what happens is you get a different
> >drop down list (with about 6 choices each) depending on what you chose in the
> >previous column.
>
> Gord Dibben MS Excel MVP
>