Excel 2007, Windows XP Macro to replicate data

[vickiecroft]

I need a macro that will replicate all rows three times. The added rows will need to be above the original row.

 

[sykes]

Please show what you've tried to do so far.
Presumably you've already done some work, rather than just say "I need a macro.........."