Using Multiple Lists
Hello,
I am trying to use lists for tracking expenses so that when you select one item in the list, then another list pops up in the next column depending on which item is selected in the list. For example, one list has broad expenses: clothing, business, food, taxes etc. If you select taxes, then in the next column you can select from a list that has state, federal, FICA etc. Can this be done using excel? I can get one list going easy enough but that's it. Thanks! |
Using Multiple Lists
Debra Dalgleish has some notes:
http://www.contextures.com/xlDataVal02.html MattPatsFan wrote: Hello, I am trying to use lists for tracking expenses so that when you select one item in the list, then another list pops up in the next column depending on which item is selected in the list. For example, one list has broad expenses: clothing, business, food, taxes etc. If you select taxes, then in the next column you can select from a list that has state, federal, FICA etc. Can this be done using excel? I can get one list going easy enough but that's it. Thanks! -- Dave Peterson |
Using Multiple Lists
Follow this link to the Contextures site:
http://www.contextures.com/xlDataVal02.html where Debra Dalgleish explains about data validation and dependent lists. Hope this helps. Pete MattPatsFan wrote: Hello, I am trying to use lists for tracking expenses so that when you select one item in the list, then another list pops up in the next column depending on which item is selected in the list. For example, one list has broad expenses: clothing, business, food, taxes etc. If you select taxes, then in the next column you can select from a list that has state, federal, FICA etc. Can this be done using excel? I can get one list going easy enough but that's it. Thanks! |
All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com