| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing output on a drop down field from two columns
Greatly appreciate any help with this.
On one worksheet called 'Budget' I have one cell that is the PROJECT field (B5) On Column A Rows 19 to 81 is a data validation list field called 'Donor' on the same worksheet. The list of Projects and their donors resides on a second worksheet called 'Data' The list looks like this Column A Column B Project Donor 01001 6374 01001 5540 01001 4303 04001 9901 04002 9915 04002 9901 What I am trying to accomplish is when a user enters a project in B5 on budget worksheet, the donor fields reference that project on the Data worksheet and list all available donors for the project. Example: User enters 04002 project Donor field shows 9901 on drop down Thanks I have an array but it is not working...thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Choose from drop down menu and get defined output in another cell | Excel Discussion (Misc queries) | |||
| Can I pull field as datafield or as a output from a pivot table re | Excel Discussion (Misc queries) | |||
| Auto Update of a field referencing to a field in another workbook | Excel Worksheet Functions | |||
| How do I change the output value of a drop down box? | Excel Discussion (Misc queries) | |||
| Referencing cells text output if it meets specific conditions | Excel Worksheet Functions | |||
Threaded Mode
