Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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" |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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" |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |