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?