+ Reply to Thread
Results 1 to 15 of 15

remove cell content based on another cells text

Hybrid View

  1. #1
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: remove cell content based on another cells text

    Check attached....
    The macro runs automatically when cell value changes in column O.
    The macro looks if there is any value in column O, if column O has any value then then the corresponding value from column L will be removed....
    Hope this helps!!
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  2. #2
    Registered User
    Join Date
    06-23-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    32

    Re: remove cell content based on another cells text

    Hi Thanks for replying.

    Nothing works on the sheet you have attached? I have also looked at the code and cannot see anything....could you copy and past the macro on here at all?

+ 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. [SOLVED] remove cell content based on another cells text
    By toneNFFC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-13-2015, 08:02 AM
  2. Automatically copy cells content based on the content of another cell.
    By chrisbarlow1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 11:13 AM
  3. [SOLVED] Search text in cells, find matching text based on list, remove all but one entry
    By adam_mc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 12:50 PM
  4. [SOLVED] Display text based on content of 3 cells
    By smugglersblues in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-20-2012, 12:25 PM
  5. Replies: 5
    Last Post: 01-28-2011, 07:02 PM
  6. How to remove certain cells based on text
    By jkupps2415 in forum Excel General
    Replies: 2
    Last Post: 06-18-2010, 03:45 PM
  7. Changing the text on button based on cell content
    By a94andwi in forum Excel General
    Replies: 1
    Last Post: 06-11-2009, 12:58 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