+ Reply to Thread
Results 1 to 4 of 4

Clear cell/remove value in the range matchin cell value in another range

  1. #1
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Clear cell/remove value in the range matchin cell value in another range

    Hi,

    attaching the sample workbook.

    What I intend to go though the range of cells consisting the values which will be matched with another range on another worksheet and in case of match clear the matching cell in the 1st sheet.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Clear cell/remove value in the range matchin cell value in another range

    Clear?
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Clear cell/remove value in the range matchin cell value in another range

    Works perfectly, thanks

    Interesting approach to use advanced filter for matching and removal

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Clear cell/remove value in the range matchin cell value in another range

    You are welcome and thanks for the rep.

    Your sheet layouts are just tailored for AdvanedFilter.

+ 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. Clear Cell range upon Changing data in difference Range
    By snuffnchess in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2016, 02:22 AM
  2. [SOLVED] Clear Content if cell in a range contain #N/A VBA
    By alex_shin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2014, 06:33 PM
  3. [SOLVED] If each cell in range equals 0 then clear contents of range and move to the next row
    By dagardner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2014, 08:44 PM
  4. Clear range based on cell value - clearing cells out of specified range
    By CADiphile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2013, 02:48 PM
  5. Replies: 1
    Last Post: 06-21-2013, 04:05 AM
  6. [SOLVED] VBA Clear Cells for one range if cell in other range is blank
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2013, 06:23 PM
  7. Clear cell range on multiple sheets if cell on one sheet is modified.
    By bjg1016 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-12-2012, 02:39 PM

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