Help with a VBA Needed

[rcirone]

I need a VBA to copy info between two date. So if I have this on a sheet1

Date Manager Agent Score
3/1/2014 Nelson Richard 80
3/2/2014 Nelson Richard 90
3/3/2014 Nelson Richard 57
3/4/2014 Nelson Richard 40
3/5/2014 Nelson Richard 100
3/6/2014 Nelson Richard 100
3/7/2014 Nelson Richard 81
3/1/2014 Pam Jeff 100
3/2/2014 Pam Jeff 100
3/3/2014 Pam Jeff 80
3/4/2014 Pam Jeff 82
3/5/2014 Pam Jeff 83
3/6/2014 Pam Jeff 95
3/7/2014 Pam Jeff 84
3/1/2014 Nelson Toni 67
3/2/2014 Nelson Toni 84
3/3/2014 Nelson Toni 85
3/4/2014 Nelson Toni 92
3/5/2014 Nelson Toni 100
3/6/2014 Nelson Toni 99
3/7/2014 Nelson Toni 100

I can get this if I pick the date 3/3/2014 to 3/5/2014 on sheet2 and so on......

3/3/2014 Nelson Richard 57
3/4/2014 Nelson Richard 40
3/5/2014 Nelson Richard 100
3/3/2014 Pam Jeff 80
3/4/2014 Pam Jeff 82
3/5/2014 Pam Jeff 83
3/3/2014 Nelson Toni 85
3/4/2014 Nelson Toni 92
3/5/2014 Nelson Toni 100

 

[hiker95]

Cross posted here:
I need a VBA for this

A message to forum cross posters, please read the following link:
Excelguru Help Site - A message to forum cross posters

 

[rcirone]

Sorry everyone I did not mean to cross post!
Here is my first post

Cross posted here:
I need a VBA for this