+ Reply to Thread
Results 1 to 4 of 4

Clear cell contents based on adjacent cell entry

  1. 01-10-2018, 03:29 AM #1
    Nigel
    Nigel is offline
    Forum Contributor
    Join Date
    07-28-2005
    Posts
    132

    Clear cell contents based on adjacent cell entry

    Hi, I am using excel 2016 and have worksheet with 2 adjacent columns formatted to Date. If for example F6 is populated with a Date and I enter a Date in G6 then I would like the date in F6 to be deleted automatically leaving any conditional formatting intact if that's possible.

    Any help would be appreciated.

    Nigel
    Reply With QuoteRegister To Reply
  2. 01-10-2018, 03:53 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Clear cell contents based on adjacent cell entry

    Try this Nigel...put code in sheet module
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 01-10-2018, 04:28 AM #3
    Nigel
    Nigel is offline
    Forum Contributor
    Join Date
    07-28-2005
    Posts
    132

    Re: Clear cell contents based on adjacent cell entry

    Many thanks Sintek for taking the time to reply. I have tried that and its not working. I have right clicked on Sheet one in VBA project, selected insert then module and copied and pasted your code so I trust Ive done that bit correctly but no luck.

    Regards

    Nigel
    Reply With QuoteRegister To Reply
  4. 01-10-2018, 05:37 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Clear cell contents based on adjacent cell entry

    See attached....Populate cells in col G with dates
    Attached Files Attached Files
    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. Macro To Populate a Cell Based on Contents of Adjacent Cell
    By sunirone in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2017, 12:16 PM
  2. [SOLVED] Find Cell that matches based on other cell contents and display adjacent cell contents
    By Bobbbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2015, 03:03 PM
  3. [SOLVED] Clear contents based on contents of another cell
    By Katrina DTE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2013, 02:44 PM
  4. [SOLVED] Macro - Clear cell contents based on other cell
    By 97hills in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-02-2013, 10:58 AM
  5. IF THEN? Auto populate a cell based on the contents of an adjacent cell - Emp # = Emp Name
    By lt.11275 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2012, 04:30 AM
  6. [SOLVED] Need help writing macro to replace one cell based on contents of adjacent cell
    By TheRaptMuse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2012, 12:54 PM
  7. Macro that will clear contents of cell based on format of text in adjacent cell
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2012, 01:56 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