I need VBA Code that will take a date range in two different columns and list a single date for each day. The code should copy the data in the row above it, accept for the Begin Date and End Date. The code should list a single date for the begin and end date. In Figure 1 the Begin Date is 01/01/2016 and End Date 01/04/2016. I would like for the code to produce the result in Figure 2. Changing the date range to a single date then put other single dates below it (Loop). The code should only work if the begin and end date is different. Then code should move to the next unique date and perform the same operation.