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.