add a line of code using zn if statement or between

[daniels012]

How can I write code to copy data from one sheet to another if the dates in a certain cell are between the begining date (cell F2) and Ending date (cell F3)

Thank you,
Michael

 

[daniels012]

If format(c.Value,"MMM") = Format(DateAdd("m", -1, e2), "MMM") Then

This works very well!!!
only, If I use the code for this Month 12/17/2005 it gives me November for the formula to work.
It copies every November month

I need just last November. That is why I want to use the G2 cell and G3 cell in the code to get => and =< to give me last November only.

Michael