I have a situation where I need to populate a list using multiple drop down lists.
For example list one contains dates (Feb wk 1, Feb Wk 2) and list two contains time period (8 weeks, 6 weeks). I then have a cell populated with list one meaning Cells A1:A2 would say Feb wk 1 and Feb wk 2. What I want to do is populate cells b1:b2 with data depending on the selection of the lists.
If in the first list a user selects Feb wk 1 and second they select 8 weeks I want the data to start populating from feb week 1 to the next 8 weeks. (the 8 weeks worth of data is on a separate sheet), I only have three week versions (8,6,4) and they are the same numbers. ie 8 weeks will always populate 1,1,1,2,2,2,3,3.
How can I achieve this?
For example list one contains dates (Feb wk 1, Feb Wk 2) and list two contains time period (8 weeks, 6 weeks). I then have a cell populated with list one meaning Cells A1:A2 would say Feb wk 1 and Feb wk 2. What I want to do is populate cells b1:b2 with data depending on the selection of the lists.
If in the first list a user selects Feb wk 1 and second they select 8 weeks I want the data to start populating from feb week 1 to the next 8 weeks. (the 8 weeks worth of data is on a separate sheet), I only have three week versions (8,6,4) and they are the same numbers. ie 8 weeks will always populate 1,1,1,2,2,2,3,3.
How can I achieve this?