pivotguy
05-17-2016, 04:35 PM
I have a input file which have date range for 5,10,15 days. I would like to extract those date range into each single rows.
See example below and attached INPUT.xls file . Can you guide me to write a VBA code. The original file contains more than thousand records .
Input File
=======
ID------ from date----- TO Date
----------------------------
1020---- 2/20/2016 ---- 2/22/2016
Output File
=======
ID----- from date----- TO Date
---------------------------
1020------2/20/2016---- 2/20/2016
1020----- 2/21/2016---- 2/21/2016
1020----- 2/22/2016----- 2/22/2016
See example below and attached INPUT.xls file . Can you guide me to write a VBA code. The original file contains more than thousand records .
Input File
=======
ID------ from date----- TO Date
----------------------------
1020---- 2/20/2016 ---- 2/22/2016
Output File
=======
ID----- from date----- TO Date
---------------------------
1020------2/20/2016---- 2/20/2016
1020----- 2/21/2016---- 2/21/2016
1020----- 2/22/2016----- 2/22/2016