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