Pull Data Based on Dates?

**okriskao** · 04-15-2009, 09:16 AM

Hi, I am not good when it comes to dates so some help will be greatly appreciated.

I have a bunch of data in a sheet, for example

A1:John
A2: 4/10/09 12:15pm

A3: Tom
A4 3/9/09 1:30pm

A5: Ron
A6: 4/7/09 5:00pm
etc.

Is there anyway I can have the user click a button and extract data that has the dates two weeks from today to a different column (C)? In the example, only A1,A2,A5,A6 will be extracted.

I know how to find cells but am not sure how to create the range for the code. Please let me know if my question is not clear enough! Thanks in advance.

**stanleydgromjr** · 04-15-2009, 12:05 PM

okriskao,

Please post your workbook - scroll down and see "Manage Attachments".

Have a great day,
Stan

**okriskao** · 04-15-2009, 03:59 PM

I can't post my workbook so I made up an example and attached it onto here. Thank you so much for your help.

**stanleydgromjr** · 04-15-2009, 07:51 PM

okriskao,

Your instructions do not match the data in your workbook.

Please post another workbook with the data on Sheet1, range B2:B5, moved to another location.

**okriskao** · 04-16-2009, 10:26 AM

This is what I wanted it to do, so the information prints out on different pages. Thanks!

**stanleydgromjr** · 04-16-2009, 07:35 PM

okriskao,

See the attached workbook "Pull Data Based on Dates - okriskao - SDG.xlsm", with a button "Move Data", that when clicked, will do as you have requested.

Have a great day,
Stan