+ Reply to Thread
Results 1 to 2 of 2

Create worksheet copy with click of button

  1. #1
    Registered User
    Join Date
    04-28-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Create worksheet copy with click of button

    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?

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Create worksheet copy with click of button

    See the code in the Summary example
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1