I need a VBA for this

[rcirone]

First I try to post this under VBA but I was not able too. 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 8
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 have a date picker and a drop list for manager If I pick a start date and the end date and then the manager
Like date 3/3/2014 to 3/5/2014 Manager Richard I like this to show on sheet2 and so on......

Date Manager Agent Score
3/3/2014 Nelson Richard 57
3/4/2014 Nelson Richard 40
3/5/2014 Nelson Richard 100

Thanks for the help

[stanleydgromjr]

Cross posted here:
http://www.mrexcel.com/forum/excel-q...ns-needed.html

A message to forum cross posters, please read the following link:
http://www.excelguru.ca/node/7

[rcirone]

Sorry everyone I did not mean to cross post!
Here is my first post
Cross posted here:
http://www.mrexcel.com/forum/excel-q...ns-needed.html

[adyteo]

I would suggest you change the title of your thread before an Admin or a Guru blocks it. Give it a clear name (read the forum rules).