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
Bookmarks