+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    39

    Post 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
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,385

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

    Try this.....

    Excel Forum Request.xlsm
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    05-15-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    39

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

    Hi Bernie,
    It did worked perfectily, But when i try to club this one with another macro, I have unable to run this.

    Can please advise where am I going wrong in the below code please


    Please Login or Register  to view this content.
    When I run the first macro, Its running properly, And then when I run the second macro, Its not running completely and neither leaves me any error msg. I am unable to reach to the end of the second macro and no msg box pops up.

    Please can you help me to identify where am I going wrong.

    Thanks
    Naresh
    Last edited by naresh73; 04-15-2014 at 10:14 AM.

  4. #4
    Registered User
    Join Date
    05-15-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    39

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

    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

  5. #5
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,385

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

    Try it this way - one sub, that calls the other for Security in Transit values:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 09-13-2013, 11:02 AM
  2. Truncate text strings using LEFT and FIND/SEARCH for multiple search terms
    By ngdoherty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 07:51 PM
  3. how to use VBA to search and return search result in the user form
    By pearlynie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2013, 07:58 AM
  4. [SOLVED] search for text, then search for previous text, replace 1st text including number from 2nd
    By kldailey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2012, 05:23 PM
  5. [SOLVED] Macro ignores search code when 1 of the 2 search parameters is not found
    By BrodyNoochie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2012, 05:21 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1