| I need to write a macro to split my excel file into multiple file based on date range. I have a excel file with following data and many other similar data Name date_of_birth A 10-01-2014 B 10-02-2014 C 10-03-2014 D 10-04-2014 E 10-05-2014 F 10-06-2014 G 10-07-2014 H 10-08-2014 I 10-09-2014 J 10-10-2014 K 10-11-2014 L 10-12-2014 I need to split the data into multiple file with each file containing data for 4 months. Could you please help me with this. Final files should be like: first.xml Name date_of_birth A 10-01-2014 B 10-02-2014 C 10-03-2014 D 10-04-2014 second.xml Name date_of_birth E 10-05-2014 F 10-06-2014 G 10-07-2014 H 10-08-2014 third.xml Name date_of_birth I 10-09-2014 J 10-10-2014 K 10-11-2014 L 10-12-2014 Thanks and Regards Bipul |
<tbody>
</tbody>