Macro to delete rows from duplicated header onwards

I have 'Stock Number" in A1

Where this appears again , I would like a macro to delete the data from the duplicated headers and all the data below it

In the attached sample data, I want the Data from A13 to A21 to be deleted

Your assistance in this regard is most appreciated

Try

Please Login or Register  to view this content.

Thanks for the help Jindon. Code works perfectly