Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
choosing off various lists
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
choosing off various lists
Hi sa,
Have a look at these: http://www.contextures.com/xlDataVal02.html http://www.contextures.com/xlDataVal13.html Regards, KL "sa" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
choosing off various lists
See this:
http://contextures.com/xlDataVal02.html Biff "sa" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
choosing off various lists
do a search of dependant lists |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
choosing off various lists
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 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
choosing off various lists
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Lists... | Excel Discussion (Misc queries) | |||
Lists... | Excel Discussion (Misc queries) | |||
VLOOKUP and Multi Lists | New Users to Excel | |||
Excel - need a function to compare lists | Excel Worksheet Functions |