Macros with multiple drown downs

[rshaf]

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?

 

[rshaf]

Anyone have any suggestions?

 

[shg]

See http://www.contextures.com/xlDataVal02.html

 

[rshaf]

I'm not sure if dependent lists solve my problem. See below for my set up:

	List ->	Feb wk 1
	List ->	8 Weeks
Feb wk 1	This is where I want the 1s,2s etc
Feb Wk 2
Feb wk 3
Feb wk 2
March wk 1

<tbody>
</tbody>

 

[rshaf]

bumping it once more