Extract data from Sheet1 to sheet2 only within specific date

hello,

i have the attached file.

i want to extract all records that fall between 02-Feb-2014 to 05-April-2015 to a new sheet.

i need help with VBA solution.
Book1.xlsx
LVL 6
FloraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
Do you do this task regularly for the same period?
0
FloraAuthor Commented:
the period might change, so it would be nice to get a inputbox to ask from which date to which date, i wanna filter .  and i do this task regularly

thank you Roy
0
Roy CoxGroup Finance ManagerCommented:
I was just checking whethet the dates would change.

You could use AutoFilter or AdvancedFilter for this one. This example uses AdvancedFilter, check it out and post back if you want help adding the code to your example
AdvancedFilter-Date-Range.xlsm
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

FloraAuthor Commented:
i am not very good with vba. i have limited knowledge.  the file you attached is completely different  solution than what i have requested and the file is not the one i have uploaded. i cannot get it work in my own file the one i uploaded.

besides you have uploaded a file from excel-it , while i thank you for your comment but i need a vba solution on my own file and not a copy paste of file from any other excel blog .

i assume there could be an easy and straight forward solution for this via VBA but i would leave this to the good experts of EE to help me.
0
Roy CoxGroup Finance ManagerCommented:
Whoa, how to make friends and influence people.

The example I posted shows you how to extract a date range using AdvancedFilter and VBA. excel-it is my website and I offered to help you adapt the code for your workbook, but I'll leave it to some one else!
0
Rob HensonFinance AnalystCommented:
See attached.

Sheet2 is the result after running Advanced Filter as suggested by Roy.

To get this follow these steps:

1) Select Sheet2 and clear all but row 1
2) Select a blank cell away from the headers on sheet2
3) From Data Tab select Advanced and you will see the input box as shown on Sheet3
4) Fill in/select ranges as per the screen shot.
5) Click OK.

if this does what you want it can be automated to a VBA routine which is probably what Roy's file had in it.

Thanks
Rob H
Copy-of-Book1-Filtered.xlsx
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Another way for you to try....

Please find the workbook and click on the Orange button to extract the data between two dates.
You will be prompted to enter the start date and end date.

See if this is something you can work with.
ExtractDataBetweenTwoDates-v1.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
FloraAuthor Commented:
this solution worked perfectly as i needed it.
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Glad it worked as per your expectations.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.