Results 1 to 9 of 9

Loop to create Multiple Tabs from 2 Master Tabs

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-04-2015
    Location
    India
    MS-Off Ver
    365 (2202)
    Posts
    314

    Loop to create Multiple Tabs from 2 Master Tabs

    Hello Experts,

    Within my excel workbook, I've 2 tabs i.e. Master and Raw.

    My requirement is to create 8 different tabs based on Master and Raw tabs.

    For instance: Initially when we run the macro, a duplicate tabs should get created of other said 2 tabs, then the tabs should get renamed to 1.0 and 1.0.

    Again on second loop, new duplicate tabs should get created of Master and Raw tab, and it should get renamed to 2.0 and 2.1.

    And so on till 8.0 - 8.1

    See attached for your reference. I've added only 6 tabs i.e. till 3.1.

    Appreciate your help in advance. Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Create 3 new tabs from master sheet
    By Bootkie2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2019, 09:55 AM
  2. Replies: 1
    Last Post: 12-15-2018, 11:06 PM
  3. [SOLVED] Create a master list of names from multiple tabs
    By rob.callaghan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2017, 10:51 AM
  4. collating multiple tabs within same workbook to create a master/summary tab
    By xotrujillo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-02-2016, 05:15 PM
  5. Can you auto create multiple tabs from enterting data in a master sheet's column?
    By ambermorr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2013, 07:28 AM
  6. Create additional tabs automatically based on input from master sheet
    By davidshluger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2010, 12:02 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