The easiest way to get started would be to record an excel macro that inserts the rows. Then view the code to see what excel is actually doing when inserting the rows. After you figure out how excel is inserting the rows, setup a loop with a variable that counts by 7 (+ the number of loops so you don't lose the existing rows) to figure out where the insertion point would be for the next 7 rows. Hopefully that'll get you started.