Macro - Every 58 rows, delete 6 rows

[glomb175]

I have an exported spreadsheet that contains 6 rows of (mostly) blank cells every 58 rows. I have a macro in a second spreadsheet that uses this data but it won't work with these blanks. I initially tried F5, special, blanks, delete, but in some of these blank rows there is data which means it pushes all of the rows out of sync if that makes sense. Is there a macro I can put in that says "every 58 rows, delete the next 6"? Or another suggestion for my problem?

[ranman256]

is the 1st row headers?
is the 2nd row blank? or data until 58 rows?

start with this:

Please Login or Register  to view this content.