Delete Certain Amount of Rows every "nth" time

[nickmessick1]

I have a file with 10,000 names on it. It is formatted where there is good data for 230 row and then has numbers/text I want to delete for 53 rows. I would like to make a macro/VBA that would keep 230 rows, then delete 53 rows, and repeat for the whole file. I have attempted to make a macro but it seems to erase too much. Example_of_issue.xlsx

[tomn13]

Is the first serial number 1? and where (what cell) does it start? And after each gap is it all sequential?

I'm really bad at writing code. But I can write something really crappy for you that would do it if you answer the above questions (maybe)

Alternatively, have you considered sorting by serial number? It should group the serial numbers togetehr and you should have all junk data at the bottom...?

[nickmessick1]

I basically copied this list from a PDF via .txt to excel, so I'm cleaning it up. I've got the info to a place where it's legible for 230 rows and then 53 rows it has lots of writing ("name" "serial") that I want to get rid of so I have one master file with personnel so I can start filtering and cool stuff like that. Some serials start with one and some with 2,3,4. I think if I can get a macro to delete 53 rows every 230th row, I'd be good. It is consistent because I got it from the internet so the file is sequential.