i have a number of rows starting at row B which give details of projects.
ProjectID, END Date, Number of Hours to complete, Number of Weeks to complete
AAA001, 15-Jan-2017, 37.5, 4
AAB002, 15-Feb-2017, 75, 5
AAC003, 20-Feb-2017, 37.5, 3
I would like each row to be copied into a new sheet a number of times (based on the number of weeks to complete), I would like the number of hours to complete to be divided by the number of weeks to complete, and I would like to Date to go back a number of weeks based on the number of weeks to complete