+ Reply to Thread
Results 1 to 4 of 4

VBA code required to insert extra/New sheets with existing sheet data

  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Thumbs up VBA code required to insert extra/New sheets with existing sheet data

    Dear all,
    I have a workbook with only 1 sheet (Sheet1) in which I have keyed in some ActiveX controls of Option buttons (Nearly 100+ in count) and completed coding related to them.

    Now I'm in need of a VBA code to do the following:
    1) Code must pop-up a input box to the user asking number of sheets required to be added into existing workbook.
    2) After user provides the data, it must add so many sheets to workbook with the same content of "Sheet1".
    3) Naming of extra sheets must be in sequence, like 'Sheet2 sheet3 sheet4.....' so on...
    4) Please make your code more general to any number of pre-existing sheets.Like if I have 10 sheets already, code must add sheet11 sheet12.....so on....If I have 3 sheets, it must add sheet4, sheet5.....so on....

    Thanks in advance.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2505
    Posts
    2,790

    Re: VBA code required to insert extra/New sheets with existing sheet data

    Try this:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Re: VBA code required to insert extra/New sheets with existing sheet data

    Thanks....Works as per my intent...

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2505
    Posts
    2,790

    Re: VBA code required to insert extra/New sheets with existing sheet data

    My pleasure.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Modifying the code in an existing workbook to add extra Category fields
    By adriantainsh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2014, 09:08 AM
  2. [SOLVED] VBA to compare data in 2 sheets, issues with existing code
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2014, 08:42 AM
  3. Get data from protected file, changes required in existing code
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2009, 06:42 AM
  4. Replies: 1
    Last Post: 08-15-2009, 05:52 AM
  5. Insert a new workbook with VBA code in the sheet module into existing macro
    By bobaftt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2009, 12:12 PM

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