+ Reply to Thread
Results 1 to 8 of 8

Delete contents of a cell if another has any contents

  1. #1
    Registered User
    Join Date
    01-15-2018
    Location
    medford, oregon
    MS-Off Ver
    2010
    Posts
    15

    Delete contents of a cell if another has any contents

    If there is anything in E4, I need to delete the contents of D4,
    and I need this to happen to all the other cells below it also, so if there is contents in E5 need to delete the contents of D5,
    all the way to E15 and D15,
    I should mention that these rows are in a table, if it makes a difference.
    thanks

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,442

    Re: Delete contents of a cell if another has any contents

    Is D4:D15 hard values, or a formula?

  3. #3
    Registered User
    Join Date
    01-15-2018
    Location
    medford, oregon
    MS-Off Ver
    2010
    Posts
    15

    Re: Delete contents of a cell if another has any contents

    Just a user entered value

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,442

    Re: Delete contents of a cell if another has any contents

    Ok, how about
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-15-2018
    Location
    medford, oregon
    MS-Off Ver
    2010
    Posts
    15

    Re: Delete contents of a cell if another has any contents

    That did not work as expected,
    Any where I click, the cells in D5:D15 get filled in with a date, unless there is something in E5:E15,
    What I need to do is treat every row individually,
    So if there is anything in E5 Delete the data in D5
    So if there is anything in E6 Delete the data in D6
    So if there is anything in E7 Delete the data in D7
    and so on..
    Last edited by new guy; 02-09-2020 at 02:24 PM.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,442

    Re: Delete contents of a cell if another has any contents

    Ok, how about
    Please Login or Register  to view this content.
    Whenever you change a cell in E4:E15 it will clear col D for that row if E has a value

  7. #7
    Registered User
    Join Date
    01-15-2018
    Location
    medford, oregon
    MS-Off Ver
    2010
    Posts
    15

    Re: Delete contents of a cell if another has any contents

    Thank you!!
    That works perfectly.

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,442

    Re: Delete contents of a cell if another has any contents

    You're welcome & thanks for the feedback

+ 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] Macro to delete contents of cells if user delete contents of other cells
    By Stuartzz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-24-2018, 08:28 AM
  2. if cell contents are equal to "no" then delete contents in other cell
    By srath in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2017, 09:56 AM
  3. [SOLVED] Delete contents of a cell in a given range if it matches contents of a specific cell
    By rcicconetti in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-13-2016, 06:46 AM
  4. Delete Rows that contain matching cell contents in column to the contents in cell B1
    By sspatriots in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2015, 05:39 PM
  5. Macro Problem: Copy contents of cell; search for contents in another workbook
    By jfishstik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-04-2014, 12:11 PM
  6. Replies: 6
    Last Post: 12-07-2012, 05:38 PM
  7. [SOLVED] Combine Cell Contents to with a [return] or [fill with spaces] between each cells contents
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2012, 11:24 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