View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stockton12 stockton12 is offline
external usenet poster
 
Posts: 4
Default I need a way to pull a list based on criteria a user inputs.

I work in a budget shop and I need to create a parameter based list on user
input.

I need a way to create a list based on they type of fund they select. For
example, if the user selects 001: General Fund, they see a list of
appropriations associated with this fund.

Data Example:

Fund Appn
001: General Fund 011: Salaries and Expenses
- FY 1
001: General Fund 012: Salaries and Expenses
- FY 2
001: General Fund 031: Grays Harbor Coastal
Erosion-FY1
001: General Fund 032: Grays Harbor Co
Coastal Erosion-FY 2
02V: Public Safety and Education Account 071: Washington Technology Center-FY1
02V: Public Safety and Education Account 072: Washington Technology Center-FY2
02V: Public Safety and Education Account 1H1: Food Distribution Program-FY1
02V: Public Safety and Education Account 1H2: Food Distribution Program-FY2
02V: Public Safety and Education Account 1P1: Community Serv Block Grant
Prog-FY1