Fill Sets By quantity and Times.

[Motilulla]

Using Excel 2010
Hello,

I want a VBA solution to Fill Sets By their quantity and with multiple times.

D2:D3 I have 2 set A & B each with 16 quantities. I need to fill them in starting row E19 to down 25 times.
If the filling A&B are followed by separate colour that will be the good.

The work is attached with explanations. Please Help.

Regards,
Moti

[JohnTopley]

Please Login or Register  to view this content.

[Motilulla]

Hello @JohnTopley, I really appreciate you time to give a VBA solution which worked exactly as appeal. But my bad as always I need bit more help please.

1-change so it can work on any letter also with (number and letters) I placed in D2=X and in D3=Y but it work only A & B, if I put D2 = F & D3 = 1 also it work on A & B. Please make it so it can work on any letters or mix with letter and number.

Please could you take a look? Thank you.

My Best Regards,
Moti

[JohnTopley]

Please Login or Register  to view this content.

UPDATED!

[JohnTopley]

Removed redundant code:

Please Login or Register  to view this content.

[Motilulla]

Removed redundant code:

Hello @JohnTopley, you are skilled VBA programmer. sorry for the trouble, Code is working flawless. I appreciate your support always.

Have a nice day. Good Luck.

My Best Regards,
Moti