Macro to copy block of rows XXX times based on number of non-blank rows on 2nd tab

[mkseto]

New to macro/VBA.
I have a worksheet (named "Details") with 6 rows of info for an account, from row#13 to row#18, and some of the rows have formulas. The second worksheet (named "Accounts") is a list of account names, which is entered by the user and each time may contain different number of accounts but always starts with row#2 (first row is column headers) and occupy consecutive rows.

I need a macro that would count the number of rows in the "Accounts" tab (i.e. row# of last account less one), then go to "Details" tab to copy row 13-19 (19 is a blank row) a total of XXX times where XXX = number of account less 1. In other words, after copying, there will be a total of XXX blocks of accounts (including row 13-18), each block with a blank row below (i.e. row 13-18 is the original block, 19 is blank, 20-25 is second block, 26 is blank, 27-32 is 3rd block, 33 is blank .... etc.).

Really appreciate any idea for a macro that would accomplish this.

[unit285]

Maybe something similar to this?

Please Login or Register  to view this content.