Hi Friends,

SPLIT DATA.xlsxI required a macro to copy the data based on the date range given in the summery sheet (From and To date) and past in the new sheet with the name mentioned in the summary sheet against the date range.

Example I have done for “Sequence 01” in the summery sheet manually. I.e. I copied the details from the sheet “Data” from 8th July to 2nd August 2013 and created new sheet in the name of “Sequence01”and pasted the copied details (including header row). Likewise I need to do for the rest of the sequences mentioned in the summery sheet based on the date range given.

Kindly help to get the macro to split the data as mentioned above.

Thanks for your support

Regards,
Prabhu