Excel Macro - Insert Rows between existing cells and copy them

Closed
TaudH
Posts
1
Registration date
Friday January 16, 2015
Status
Member
Last seen
January 16, 2015
- Jan 16, 2015 at 04:05 PM
I'm trying to create a macro that inserts 49 blank rows then fills them with the first row, but I need this to be on a loop because I have 800 entries. Unfortunately, I have very little programming knowledge.

Here is a sample.

Currently:

Last Name Start time Finish Time Date
Smith 5 10 1/16/2015
Dawn 6 11 1/16/2015
Daniels 8 10 1/16/2015
James 5 10 1/16/2015



After Macro (Scaled down to 5 instead of 50 repeats)

Last Name Start time Finish Time Date
Smith 5 10 1/16/2015
Smith 5 10 1/16/2015
Smith 5 10 1/16/2015
Smith 5 10 1/16/2015
Smith 5 10 1/16/2015
Dawn 6 11 1/16/2015
Dawn 6 11 1/16/2015
Dawn 6 11 1/16/2015
Dawn 6 11 1/16/2015
Dawn 6 11 1/16/2015
Daniels 8 10 1/16/2015
Daniels 8 10 1/16/2015
Daniels 8 10 1/16/2015
Daniels 8 10 1/16/2015
Daniels 8 10 1/16/2015
James 5 10 1/16/2015
James 5 10 1/16/2015
James 5 10 1/16/2015
James 5 10 1/16/2015
James 5 10 1/16/2015

Is there already a macro out there that does this?