Macro to create a looping macro to populate another worksheet.

This is looking good. Let ask if this is working the following way as I don’t understand the code.

On the Inputs page:
Start Date using the calendar option. LOVE IT!
End Date looks like it auto populates to the last line in the Settlement Prices sheet? I tried to change it to 6/10/16 and when I ran the macro it still showed 6/15/16.
When you click the process button
Does it place the first date in cell B4 on Inputs? I need that to happen. Also at that time can you note where in the code where that happens so I know where to CALL MACRO2.

Next it will go to the Output page:
And copy K2:M2 to the next available line in A:C. (your will see I changed the data1 and data2 lines to be “0” as I just need it to copy whats in K2:M2). Once I know where to place my CALL MACRO2 IT will give the math that will be fed into K2 and M2.
I might have confused everyone but showing the data. Perhaps I should have JUST shown the dates.

This will complete what i need to be able to finish the program.