I'm creating a account-opening form with 3 sheets.
Sheet 1 has instructions.
Sheet 2 has a form with 25 rows. For every new account requested, customer uses new row.
Sheet 3 has a form with detailed questions about the new account/s.
Customer always requests multiple accounts. Often, he requires only one copy of Sheet 3 form because all accounts are similar. However, sometimes, he will require more than 1 copy of Sheet 3 form. For example, he may request 10 new accounts and have 6 that are similar in nature and 4 that are not. In this case, he will require 5 copies of the Sheet 3 form.
Is there anyway to dynamically create these copies? Workbook is protected so customer cannot create these copies. I want to have a button that asks the customer if more copies of Sheet 3 are needed and create them dynmically.
Is this possible?
Bookmarks