Macro to find cell containing Gross weight and run another macro

Step 1:

I want range to be selected from A19 cell to A column used range and want to find cell containing "gross weight" and run another macro

Step 2:

I want new blank row added below "gross weight" cell

I want it to loop it until there is no data

Step 3:

I want range to be selected from A19 cell to A column used range and find cell containing "page no" and delete that entire row

Please support

Maybe something like this?

Please Login or Register  to view this content.

@unit285

No it's not working

Can you explain what it does that is not working? Your initial post is a bit lacking for what you need help with. Maybe attach a copy of your workbook so i can see for myself?

Well I have put alternate method to get it done.