+ Reply to Thread
Results 1 to 8 of 8

the code is finding repeated values but i need to search values from E column to D

  1. 10-13-2014, 12:48 AM #1
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    the code is finding repeated values but i need to search values from E column to D

    i have one column(SEARH WORD) Where i has some words
    like
    CABLE
    CONNECTOR
    CLIP
    BELT....ETC

    I NEED TO FIND THIS WORDS IN OTHER COLUMN (XX) AND MARK COLOR(YELLOOW)



    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-13-2014, 01:27 AM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: the code is finding repeated values but i need to search values from E column to D

    Hello baig123,

    Try this macro and let me know th results.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 10-13-2014, 01:36 AM #3
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: the code is finding repeated values but i need to search values from E column to D

    No its dosent display any output

    i have already specified words in column e what to find in column(d)

    i need to run macro search in the column d

    here searching for multiple values like

    BELT
    CAble
    CONNECTOR
    CLIP
    CLAMP
    Last edited by baig123; 10-13-2014 at 01:40 AM. Reason: PARAGRAPH
    Reply With QuoteRegister To Reply
  4. 10-13-2014, 01:50 AM #4
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: the code is finding repeated values but i need to search values from E column to D

    Hello baig123,

    Are you searching for full word matches or part word matches?

    Do you want highlight the cell if any of these words are found?

    Please provide accurate details about what you want to do.
    Reply With QuoteRegister To Reply
  5. 10-13-2014, 02:01 AM #5
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: the code is finding repeated values but i need to search values from E column to D

    yes i am finding both part words

    i want to highlight with color mark yellow for cells

    sorry for any confusion
    Last edited by baig123; 10-13-2014 at 05:06 AM. Reason: paragraph
    Reply With QuoteRegister To Reply
  6. 10-13-2014, 01:46 PM #6
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: the code is finding repeated values but i need to search values from E column to D

    Hello baig123,

    It took quite a bit of time for to verify the macro was working correctly due to the large data set. A button has been added to the sheet to run the macro below.

    Each cell in column "D" is checked for any of the words in column "E". The case is ignored and full words only are matched.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 10-14-2014, 12:52 AM #7
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: the code is finding repeated values but i need to search values from E column to D

    thanks for helping leith ross
    Reply With QuoteRegister To Reply
  8. 10-14-2014, 01:33 AM #8
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: the code is finding repeated values but i need to search values from E column to D

    Hello baig123,

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. i am trying find repeated values in the column but it is finding only one repeated values
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2014, 04:52 AM
  2. create list of unique values from a column with repeated values?
    By Chad Schaben in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  3. [SOLVED] create list of unique values from a column with repeated values?
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  4. create list of unique values from a column with repeated values?
    By Chad Schaben in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] create list of unique values from a column with repeated values?
    By Chad Schaben in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1