I am having a hard time articulating my need. So, I don't know the key words to use that will find a solution.
I have three columns:
- Project_Number
- Line_Item
- New_Line_Item
A Project_Number can have 50-100 Line_Items.
I am trying to provide a select list populated by Line_Items associated with the Project_Number. The user will use the select list to transfer funding from one Line_Item to another.
This is a simplistic representation of my data. Actual data is not so orderly. I'm just trying to show the concept. The value of the New_Line_Item cell would be selected from a list of Line_Items that have "P1" in the Project_Number column.
A B C
1 Project_Number Line_Item New_Line_Item
2
3 P1 P1-A01 Drop down list with values P1-A01, P1-A02, P1-A03
4 P1 P1-A02 Drop down list with values P1-A01, P1-A02, P1-A03
5 P1 P1-A03 Drop down list with values P1-A01, P1-A02, P1-A03
6 P2 P2-A01 Drop down list with values P2-A01, P1-A02
7 P2 P2-A02 Drop down list with values P2-A01, P1-A02