Copy Rows based upon Month

[rimartinez]

I have a workbook that has data that a user will enter into one row. On every row the user inputs data for an order along with the begging date for an order and the ending date for the order. I need to create a button that will copy the row and paste the data down for each number of months that are between the period. Also, if possible the new rows would contain all the data copied plus a reference to each month the row represented.

For instance, the user may put the order begins Jan 1st and Ends June 30. This row should be copied 5 times. For instance, one row would say Jan, next row would say Feb, next row March and so forth.

Any help is greatly appreciated. Thanks!