Trying to compile macros - Tough one

[priyadharshane]

Hi Lads,

I'm trying to compile many macros into single automated one. I need guidance on all below queries with macros

1) I have macro to remove duplicates. Is there macro to see content of three or more columns and delete row only if all three matches if not skip it. Also, it should not delete empty rows

2) Is there macro to Page No. 002 ASN,Page No. 003 ASN? It's not removing since 002, 003 and go on are dynamic? Better I need macro to delete row if column A starts with Page no. except first one which is header

3) Since Im trying to compile macros. I need a loop macro on enclosed picture. FYI, content of Macro 1 are dynamic as it's a packing list

2019-02-12 19-02-10_Packing list Template.xlsm - Excel.png

I cannot share excel file since it's wrong

[priyadharshane]

It will be good if anyone support on this