Is there a way to use a macro with an Excel form?

**deniseb27** · 03-02-2020, 07:38 PM

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!

**mehmetcik** · 03-02-2020, 10:59 PM

Welcome to the forum

Yes that is easyly done,

Please Login or Register  to view this content.

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**deniseb27** · 03-04-2020, 03:54 PM

Thanks so much for replying! I'm doing something wrong - not sure what. Is there a way for the excel form to prompt a user to indicate how many rows need to be copied down for each entry?
Thank you