Hello,
I am trying to create a drop down list that when selected will display data in the 10 rows below and 4 columns, so a total of 40 cells. I would like the data to be based on the selection in the drop down list.
The data looks like this,
Requirements Qty Resources Qty
Level 1 Sentinel 10 Level 1 Sentinel 105
Level 2 Sentinel 10 Level 2 Sentinel 167
Level 3 Sentinel 10 Level 3 Sentinel 156
Level 1 Banga 20 Level 1 Banga 401
Level 2 Banga 20 Level 2 Banga 307
Level 4 Banga 20 Level 4 Banga 0
i have 27 different combinations of the above list with up to 10 different rows. I have a label for each one, but i cannot get the rows below my drop down list to display the proper values base don the selection in the drop down list.
Any help is greatly appreciated.
Bookmarks