Macro to copy the data based on date paste it in a different sheet

[srinidhi]

Column C has dates, Column D has numbers & Column E to N has different data.

I want the macro to copy all the rows from C to N based on the start date (01-April-2011 it is in month-date &Year format) C column is incremental, at the end of dec-11, it will have all the dates from april-dec. All the data starting from 01-April-2011 & above shld be copied to sheet 2

 

[Luke M]

Either just use an Advanced Filter, or record a macro of yourself doing so.

Intro to Adv Filter:

http://www.contextures.com/xladvfilter01.html