Delete repeating heading rows

hi

I have a spreadhseet with multiple headings rows segregating different type of data.

For example Row 1, Row 50, Ro 60 have headings.

Row 1 will always have headings. Other rows with headings may be row 50 or 55 or 60 etc.

I want a VBA code which finds rows which are same as Row 1 and deletes the rows. The rows may be somewhere in middle and the rest of the data should shift up.

Can you please help me?
Thanks

Originally Posted by royUK

Are the headings exactly the same and the text does not appear within the rest of the data?

Also, are there any blank rows within the data?

The heading rows are exactly the same.

There are some blank rows in the data as well. I also need to remove these blank to get correct results from autofilter.

Originally Posted by royUK

Remove the blank rows - try using Sort, then autofilter for the header. Then delete.

I can't see why yo need a macro.

I know how to use sort and autofilter to find blank rows.

I need a code to delete duplicate rows and blank rows so that i can use it in my macro so it functions properly.

I have managed to write code for deleting blank rows, so only need code to delete duplicate rows.

Thanks