+ Reply to Thread
Results 1 to 3 of 3

create macro to delete row with a date previous to current date

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    Hawaii
    Posts
    2

    create macro to delete row with a date previous to current date

    I want to have my spreadsheet automatically delete rows that have dates previous to whatever the present date is. I am very new at this, so it would be great if you started from scratch. My column of dates is in column A.

    Thank you.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Is there a Header row and data in the orther columns to delete?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-25-2008
    Location
    Hawaii
    Posts
    2
    Yes, I have three columns of data. Row 1 contains titles for each column. Column A contains a list of various dates. I would like to have the old dates and all other data in the same row as the old date automatically deleted.

+ 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. create a macro to alert me if today's date is within 5 days of expected delivery date
    By ashmcclure in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-25-2008, 05:51 PM
  2. generating date range from current date
    By dexelguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2008, 04:52 PM
  3. Macro to create new sheet
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-21-2008, 01:15 PM
  4. Macro to Create Control Chart in Excel
    By ebachenh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2006, 01:52 PM
  5. Macro to create new sheets from master data sheet
    By adsigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 09:21 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1