Take data in one worksheet and merge each row of data into a form on a new worksheet

[cnorenbe]

I have been asked to work with an existing Excel form. One page is where sales reps enter data and then they want that merged onto another worksheet in the same workbook where they will then add specific information relating to the order. They then want to print the form. They may have one row or 30 rows. They want me to use the form as it is. I have been trying to figure it out for over a week with no luck.

I figured out how to automatically schedule the install date during the week excluding weekends and holidays. Now I need to figure out how to get it to print a new worksheet form for each record they mark to print.

Any help would be very much appreciated!

Thank you!
Colleen