+ Reply to Thread
Results 1 to 6 of 6

copy specific tabs to new workbook based on TAB NAME

  1. #1
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Post copy specific tabs to new workbook based on TAB NAME

    Seeking help to create VBA code for the below


    I want to copy specific tabs to new work book, based on TAB names

    All Sheet Tab Names are coming text_sheet name

    If User Type Text of Before underscore, through message box, respective text tabs to be copied to new workbook

    like if user typed AP

    The below tabs to be moved to new workbook

    AP_test TAB
    AP_Test TAB (2)


    If User typhed P2P
    P2P_TEST DATA
    P2P_TEST DATA (2)
    P2P_TEST DATA (3)
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: copy specific tabs to new workbook based on TAB NAME

    Please Login or Register  to view this content.
    Last edited by sintek; 05-19-2021 at 03:54 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Re: copy specific tabs to new workbook based on TAB NAME

    Thanks Sintek


    I am getting msg box as "NO TABS MATCHING PREFIX", seems i am putting wrong input?

    i am typing the input as "AP" (without quote) and tried AP_ also same msg box only coming

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: copy specific tabs to new workbook based on TAB NAME

    See attached...............
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Re: copy specific tabs to new workbook based on TAB NAME

    I have changed the below line as active workbook. its working perfectly

    Please Login or Register  to view this content.
    Thank you so much for your help

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: copy specific tabs to new workbook based on TAB NAME

    Glad I could assist...thanks for rep +

+ 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. [SOLVED] vba to copy specific sheet to new workbook based on a cell value
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2017, 09:25 AM
  2. Copy specific cells in a row from one workbook to another based on Cell value
    By prvnchdry in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-12-2017, 03:44 AM
  3. [SOLVED] Copy certain tabs to a new workbook based on criteria
    By djro69 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2017, 02:15 PM
  4. Replies: 0
    Last Post: 05-26-2015, 04:31 PM
  5. Replies: 0
    Last Post: 05-08-2013, 02:47 PM
  6. copy rows to specific worksheets in another workbook based on a condition
    By AngelaM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2012, 12:36 PM
  7. [SOLVED] VBA to copy specific data from one workbook to another based on today's date?
    By hiprhit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2012, 02:21 PM

Tags for this Thread

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