I have taken the liberty of attaching a new file. It will simulate the results of what the after effect would be after the macro is run.
As you can see on INPUTS the starting line number for Data extraction is 112 which coincides with 6/8/16 on the SETTLEMENT PRICES Page. SO the Macro now knows to start at line 112 and continue until the last line of data is examined (in my example that number is found on INPUTS B2).
So as you can see the macro is supposed to take the data for that specific day and post it to the OUPUT Sheet.
So I was thinking the flow of this macro would go something like this:
User enters the starting line number in B1 on the INPUTS page (112 in this example) and clicks the Process Button.
The macro knows that the LOOP is going to be 6 long 112 through 117.
The macro then pastes as a number the first date (in this case 6/8/16) into INPUT B4.
When the date is entered into B4 it will auto populate F2 and G2 (which in turn will populate K2, L2, and M2 on the OUTPUT page.
The macro will then select the OUTPUT page and copy as values K2:M2 into the next open row in A:C.
The macro will then select the INPUTS page again and change the date in B4 (in this case to 6/9/16)
The macro will then repeat the process again as described above for 6/9, 6/10, 6/13, 6/14, and finally 6/15.
As you can see this is only 6 lines of data but the real program when complete will be 100’s long and the formula used in F2 and G2 on the INPUTS page will be MUCH more complex.
The problem is I am NOT a VBA programmer but rather a good HACK.. If I have the basic macro to do the above request I can ADD more details to it once I see the structure and understand how it works.
SIDE NOTE:
What WOULD be cool would be to be able to enter the DATE into B! on INPUTS and not the line number associated with the date…….
Thank you again for your help with this!
Bookmarks