Copy and paste a value x times dependent on value of cell

JSes1402 Posts 1 Registration date Tuesday November 1, 2016 Status Member Last seen November 1, 2016 - Nov 1, 2016 at 03:32 PM

I am looking to make a macro which will copy and paste a value into a column x times depending on the value of x... After it has copied this, I would like it to move onto copying a different cell y times below it. And so on...!

100% 22
75% 10
66% 10
50% 10

So, for example, I would like 100% copied 22 times into column C starting from cell C1 and then 75% copied 10 times into column C but starting from where the 100%'s stopped and so on for 66% and 50%.

Once these are copied, I would like to copy these values to the column set by a drop down menu. Would this be possible to?

Thank you in advance for any help you can all give!