AutoFill range based on cell value

[BlokeMan]

Hi,

Drop down list value is in D2, based on that value it will autofill range B2:B31. If the value selected in D2 is 24 then Autofill range B2:B31 to 24,48,72 to 720, same as when selected 30 then 30,60,90 to 900. I would like to do this in macro.

Thanks

 

[BlokeMan]

Hi Peter,

You're a genius, once again thanks for your help, you didn't give up on me.

 

[Peter_SSs]

Hi Peter,

You're a genius, once again thanks for your help, you didn't give up on me.

Cheers. Glad we got there in the end.