+ Reply to Thread
Results 1 to 3 of 3

Macro to delete dates > xx date

  1. #1
    Registered User
    Join Date
    02-08-2005
    Location
    Kent, UK
    MS-Off Ver
    2010
    Posts
    69

    Macro to delete dates > xx date

    I have a report that has various tasks along the top and various sites along the site. The data in the table are forecast dates where they have dates.

    I'd like to have the same report but only show dates less than a certain date (for example to show past dates or dates due this month, etc.). I'd like to have the macro show an input box where I can enter the date. But is it possible for the macro to then delete any dates that are greater than the entered date?

    I know I can use conditional formatting to 'hide' the dates but I'd prefer them to be deleted instead - as it would help with my next task.

    I fear this might need some sort of loop that would slow the macro down considerable?

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Macro to delete dates > xx date

    koltregaskes,

    Something like this?
    Please Login or Register  to view this content.


    Hope that helps,
    ~tigeravatar

  3. #3
    Registered User
    Join Date
    02-08-2005
    Location
    Kent, UK
    MS-Off Ver
    2010
    Posts
    69

    Re: Macro to delete dates > xx date

    Ta, so how exactly does this work? :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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