| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering data using a drop down menu
here is what my spreadsheet looks like
STATE PROGRAM FUNDING Budget NY Mobile 311 $ 2,132 NY Mobile 311 $ 6,563 NJ Stationary 311 $ 8,125 Total $16,820 CT Mobile 425 $5,623 FL Stationary 425 $2,244 CA Stationary 425 $8,265 NY Mobile 425 $1,898 Total $18,030 NJ Mobile 366 $16,000 CA Stationary 366 $2,000 Total $18,000 I need to create drop down menus so that if I need to run a report on all the programs in NY, it will automatically filter out all the rest. or if i need to run a report on what type of program etc. For some reason, I cant figure out the filter option. and the rows in between that show the totals for each Funding Code is also throwing me off. I have seen another office use this format with no problems but they didnt create the spreadsheet so they cant help me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modifying Data in Drop Down Menu | Excel Worksheet Functions | |||
| Data drop down on the menu bar missing | Excel Discussion (Misc queries) | |||
| Drop down menu with Dynamic data | Excel Discussion (Misc queries) | |||
| help with drop down menu data | Excel Discussion (Misc queries) | |||
| Filtering Data with a Drop Down field | Excel Worksheet Functions | |||
Threaded Mode
