VBA Copy&Paste Loop under sertain conditions

Hi forum,

I am really new to VBA and I need to create a macro far beyond my skill and hit a brick wall;

I think I need many layers of loop, but if there's more elegant way please teach me.

I basically need to repeatedly copy&past store named "x" amount of time based on PO instruction conditioned by Grade and Zone type.

Please check the attached file for more info.

Many thanks in advance,

Cheers!

Thanks for replying!

Yep, that simply mean both stores have same grade and zone type.

So if the PO# 2001515 instruction is All zone type A-5 B-3 C-1;

It means copy and paste any stores that are in any zone type and grade A 5 times then do the same for B grade 3 times then do the same for C grade 1 time.

The result is [Output Example] tab

Cheers,

I assume the PO# will be the activecell before running the macro? Is that correct?

I am really sorry for not coming back to this.


But I decided to take a different approach and solved this issue.

Thanks everyone for your replies - Especially, humdingaling.

Your reply taught me a lot!

Cheers,