Copy and Paste Range of Cells based on # of cell values in Column A

Hey all,

Please see attached sample worksheet.
Column A will be generated by the user manually.

I'm looking for a way in VBA to have A1:D20 in Sheet2 copied and pasted in the "Bank Reconciliation" Sheet based on how many "Markets" there are in Column A. Then, once that's complete to have A22:D30 (the smaller box in Sheet2) copied and pasted directly below those results.

I have what the macro would hopefully generate to the right in "Bank Reconciliation" (B6:E54) as an example.
So if there's a market in A1, copy and paste the box to B6.
If there's a market in A2, copy and paste the box directly below the first (B26)
etc. etc. until it's done, then paste the smaller box directly below whatever the macro generates.

My apologies if this isn't clear...had a very long day...

Any help would be greatly appreciated.

Thanks!!

Try this:

Please Login or Register  to view this content.

Thanks stnkynts, that worked perfectly!