+ Reply to Thread
Results 1 to 2 of 2

Can you have cells delete at certain date?

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    Fort Eustis
    MS-Off Ver
    Excel 2010
    Posts
    3

    Can you have cells delete at certain date?

    hello again,

    Can you have excel delete certain cells after a selected date? for example class graduates on Nov 27 13 have selected cells with class info delete off spread sheet after two days? and if so can remaining cells shift up while leaving empty cell for new class info?

    thanks you

    V/R

    SGT Roy

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Can you have cells delete at certain date?

    Can be done easily with a simple macro. What is your structure? Where are the cells to be deleted? Where are the cells containing the expr. dates?
    Gary's Student

  3. #3
    Registered User
    Join Date
    11-14-2013
    Location
    Fort Eustis
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Can you have cells delete at certain date?

    row b3-k3 needs deletion two days after the date in D3 which is 27 nov 13

+ 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] Delete range of cells based on a cell value (Date).
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-06-2013, 05:21 AM
  2. Find a date value in a sheet and delete all cells to the right of it in the row
    By pajc72 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2013, 11:05 AM
  3. Delete cells value based on date
    By yjmmay34 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2010, 05:12 PM
  4. Auto Delete three cells on Aniversary (date)
    By shaun0_0 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-16-2008, 08:43 PM
  5. auto delete cells according to date
    By LiquidDragon in forum Excel General
    Replies: 3
    Last Post: 12-06-2008, 12:55 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