Hi Everybody,

this is my duplicate post. can somebody help me? i am in urgent need.

Please help me to have a macro for the below procedure;

let me explain. Say book1 has total 12 sheets named S1 to S12. Each Sheet contain data date wise, in the data column C has dates and rest of the columns upto CG have data against dates. I need your help to have a macro that pop up message to select start date and end date, it should copy the entire row between dates selected and paste them into another workbook say book2 containing 12 sheets named S1 to S12. Book1, S1 data should go to Book2, S1 and so on."

Regards
Quaidian