Share via

Delete rows by date range

Anonymous
2010-10-07T20:51:22+00:00

Hi there,

I have a spreadsheet that has lots of data with column C being the date (dd-mm-yyyy). Is there a way for me to create a macro that would keep the data within a specify range  (say something from 30/10/2010 to 30/10/2011) and delete all other rows where the dates are outside of the specified range? Perhaps something with an input text?

Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-09-05T02:00:19+00:00

    I'm using Excel 2007.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-10-07T20:52:38+00:00

    Which Excel version do you use ?

     --

    Regards Ron de Bruin

    http://www.rondebruin.nl/tips.htm

    "tombstone123" wrote in message news:*** Email address is removed for privacy ***...

    Hi there,

    I have a spreadsheet that has lots of data with column C being the date (dd-mm-yyyy). Is there a way for me to create a macro that would keep the data within a specify range  (say something from 30/10/2010 to 30/10/2011) and delete all other rows where the dates are outside of the specified range? Perhaps something with an input text?

    Thanks.

    Was this answer helpful?

    0 comments