VBA Code - Search text & search number & search qty and result - Urgent Please

Hi All,

Need some favor of you VBA Experts please.

Need a MACRO that should search for specific text “Security in Transit” from column “AD” and if yes then the text “Security in Transit” need to be populated in Column “L” in the same row and then, Should look for the respective account number from the same row in Column “J” and search for the opposite BIG_QTY in column “Y” for the same account number if yes, then it should populate the text “Security in Transit” in Column “L” for all the rows that match with account number and opposite Big_Qty number in Column "L"

2 Criteria’s for Security in Transit in Column “L”,
1. Description with “Security In Transit” then Column “L” should populate “Security in Transit”
2. For all the account numbers from Column “J” with “Security in Transit” in Column “L” and the Column “y” with opposite Big_Qty should populate Security in Transit.

However I was able to do until searching the text from Column AD and populating the required text in Column L, however couldnt do the second match if (Account Number) and then search if (Opposite Big_Qty) condition in VBA.

Any help in this much appreciated please..It little urgent friends..

Thanks
Naresh

Reporting Data Sample.xlsx

Hi All,
If it did worked perfectly, However When I try to club this MACRO with another MACRO, I have issues,

Please Login or Register  to view this content.

First MACRO is running properly, However the Second one is not running completely and neither leaves me any error msg, and I canot see the second msg box also.

Please help me to find where am I going wrong in this.

Thanks
Naresh