I have an excel doc where users enter five data points - let's say they are: Name, Number, Class, Date, and Hours. The Date field is a data validation field - it displays each Monday in a date form. I also have a form so the user can either fill out the form or enter the info direct in the cells.

I'd like to be able to add a feature whereby the user can say they need to copy the data x amount of times, so the five data points from A1:A5 will copy the data to B1:B5 and C1:C5 if they need it three times, or for three weeks. Can this be done either in a form or without a form? If cells D1:D5 display John Smith | 12345 | Class 123 | March 2 | 9:00, is there a way I can say the assignment is for four weeks so it would populate D1:D5 through G1:G5 with the data copied down four times, preferably with the next three dates in the fourth field (i.e. March 2 in D, March 9 in E, March 16 in F and March 23 in G?

Thanks!