| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making the drop down list of a cell depend on another cell
I want to catagorise my spreadsheet entries, into seperate catagories eg:
Works/Services, Fundraising, Bar/Fridge, Misc, etc, with each of these catagories having further classes inside them ie Fundraising contains: Chocolates, Open Day, Donations etc. I want to do this so I can sort and work out (using a pivot Table) income and expenses on each class. Thanks for the Help, Jarrod |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making the drop down list of a cell depend on another cell
Hi Jarrod
check out http://www.contextures.com/xlDataVal02.html I think this is what you're looking for. -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "Jarrod" wrote: I want to catagorise my spreadsheet entries, into seperate catagories eg: Works/Services, Fundraising, Bar/Fridge, Misc, etc, with each of these catagories having further classes inside them ie Fundraising contains: Chocolates, Open Day, Donations etc. I want to do this so I can sort and work out (using a pivot Table) income and expenses on each class. Thanks for the Help, Jarrod |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making the drop down list of a cell depend on another cell
Thanks for the fast reply Julie, I managed to find the info (the one you
listed) just as you posted! Regards Jarrod "JulieD" wrote: Hi Jarrod check out http://www.contextures.com/xlDataVal02.html I think this is what you're looking for. -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "Jarrod" wrote: I want to catagorise my spreadsheet entries, into seperate catagories eg: Works/Services, Fundraising, Bar/Fridge, Misc, etc, with each of these catagories having further classes inside them ie Fundraising contains: Chocolates, Open Day, Donations etc. I want to do this so I can sort and work out (using a pivot Table) income and expenses on each class. Thanks for the Help, Jarrod |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add rows depend on the number in a cell | Excel Worksheet Functions | |||
| how to calculate depend on drop-down list value? | Excel Discussion (Misc queries) | |||
| Auto run macro depend on cell value | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell? | Excel Programming | |||
Linear Mode
