Macro to delete rows up to "Chassis"

[Howardc1001]

I have written code to delete rows up to before where chassis appears in Col A on sheet "imported data"


It only deletes this in the first instance. I need the rows deleted up to before chassis each time chassis appears

Please Login or Register  to view this content.

I have attached sample data. I have shown what it should look look like after running the macro on sheet "result" to show what i require

your assistance in this regard is most appreciated

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help. Code works perfectly