Add Multiple Rows to Differing Variables

Good Morning,

I am trying get a VBA code that will add multiple rows given the amount of weeks between a date. I have attached an example spreadsheet with the original data that I have, and also what I require.

Basically if a row has six weeks between a loan of an item, I need 5 rows inserted with the start date and end date of each week between the loan period, with the rest of the cells remaining the same. The next loan is then say 5 weeks, so I need 4 lines inserted with the start week and and week changed. I guess the support ID in the example is the constat that will differentiate each loan period.

This is required so I can graph the qty of the loans over a period i.e monthly, 3 monthly or my choice of period. I am hoping the example is self explanatory, if not, I can try and clarify more if you have questions.

Kind Regards

Matthew