Extract the data within the specific date range

[nth34]

Hi guys,

Sorry to bother you guys,

If i have a few columns and rows of data

For example

A B C D
Tom HK Boy 1/1/2015
Peter US Boy 10/3/2001
Mary UK Girl 7/2/2015

If i wanna extract the entire row, with the speific date range, like after 1/1/2015,
wanna move the entire row to a new sheet for record, and before 1/1/2015,
wanna start another new sheet for record.

I have used lots of dumb ways, like change the date into numbers, and rearrange them and copy to the new sheet,
but cant vlookup the data through the date, because the date may get the same.

Wanna take it simple.

Hope you guys can teach me a solution. Thank you so much guys!

[LokeshKumar]

Hey
Could you upload the workbook with expected results.....

[nth34]

Hey
Could you upload the workbook with expected results.....

Yes sure sir. Once i am home.will upload here.thank you for your reply sir

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[nth34]

Sorry for the late reply,

here is my example.

But the row is in dynamic change..

For those date >2015
put them into sheet("2015")

and the rest put into non2015

[nth34]

Does this help?

Please Login or Register  to view this content.

my situation is consists of data, but i will try to look into it, to find is there any possibile to happen to me.
Thank you so much for your answer and time!!

[jindon]

Autofilter would be the best fit for this

Please Login or Register  to view this content.

[nth34]

Thank you so much sir!!
It works perfect!!

[jindon]

You are welcome and thanks for the rep.