+ Reply to Thread
Results 1 to 3 of 3

Match Cell Content and Delete Cell Content If a Match is Found

  1. 07-29-2013, 07:26 PM #1
    aviatecar
    aviatecar is offline
    Forum Contributor
    Join Date
    06-29-2012
    Location
    Calgary CA
    MS-Off Ver
    Excel 2010
    Posts
    117

    Match Cell Content and Delete Cell Content If a Match is Found

    Hi Gurus:

    I am trying to get a VBA code to help me search the content of a cell from another cell,and delete the matched content from the second cell.

    A sample file is attached and a Pseudo code is written.

    Thanks and have a wonderful day!

    Chris

    1-PM TO INTERAL-find a match and delete.xlsx
    Reply With QuoteRegister To Reply
  2. 07-29-2013, 11:12 PM #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,258

    Re: Match Cell Content and Delete Cell Content If a Match is Found

    Hello aviatecar,

    This macro will do what you want. It is included in the attached workbook.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    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. 07-30-2013, 01:29 PM #3
    aviatecar
    aviatecar is offline
    Forum Contributor
    Join Date
    06-29-2012
    Location
    Calgary CA
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Match Cell Content and Delete Cell Content If a Match is Found

    Quote Originally Posted by Leith Ross View Post
    Hello aviatecar,

    This macro will do what you want. It is included in the attached workbook.
    Please Login or Register  to view this content.
    Thank you Leith,

    The code works like a charm.

    Chris
    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. IF same CONTENT FOUND IN CELL A THEN DELETE CONTENT IN B,C or D
    By mecutemecute in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2013, 01:16 AM
  2. How to examine the content of a range and to delete a cell below a value found
    By sundial in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2013, 04:03 PM
  3. Lookup values in one cell, if they match copy content of another cell to different sheet
    By ezay in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2012, 03:42 PM
  4. [SOLVED] Highlight a cell if its content doesn't match another cells content
    By noxygen in forum Excel General
    Replies: 4
    Last Post: 04-12-2012, 04:36 AM
  5. match entire cell content and delete row
    By hluk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-30-2009, 04:09 AM

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