need blank rows between existing rows

I have a spreadsheet with tabs that have info on up to 100 or so rows. I would like to put a blank row between each existing entry. Is there an easy way to automate this, or do I just need to instert them manually?

A macro can do this for you....
Arrgh....NEVER manual....

Must there be blank rows between each record for ALL records on ALL sheets?

This code should do the job...

Please Login or Register  to view this content.

Here are two samples. First Sample is the spreadsheet I get, Second Sample is how I want it to look so I can copy/paste the team names into the spreadsheet I am writing.

The macro I posted should work....
One small change, so it does not add a row at the top...

Please Login or Register  to view this content.

Excellent. You folks always make me look so good!

thanks!!