+ Reply to Thread
Results 1 to 4 of 4

Copying a range of tabs in one file to the end of another file

  1. #1
    Registered User
    Join Date
    05-11-2008
    MS-Off Ver
    2010
    Posts
    91

    Copying a range of tabs in one file to the end of another file

    Ok so I currently have 5 separate files with say about 10 tabs in each file (each file represents a different division of the company). On a monthly basis I need to consolidate all of these tabs in each of the 5 files into one master file. Is there a way for me to select a range of tabs (say Sheet1 - Sheet10 for example) and copy this and move it to the consolidated file, but move it to the end of all the tabs that may already be existing in the consolidated file? I know how to toggle between files using the ActiveWorkbook.Name code, but am a little stumped on how to copy tabs between the two files. Can the range of tabs in each file be copied all at the same time or would I need to loop through each tab and copy them one by one? TIA.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Copying a range of tabs in one file to the end of another file

    som3on3_10
    one easy way
    if you have both workbooks open
    right click on the sheet tab you want to move_ you can select one or more sheets Ctrl and click on tab
    select move or copy
    change Book to:to the second workbook
    Before sheet: (move to end)
    check copy box
    then OK
    Last edited by pike; 04-15-2011 at 08:04 AM. Reason: you cant select more than one sheet
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    05-11-2008
    MS-Off Ver
    2010
    Posts
    91

    Re: Copying a range of tabs in one file to the end of another file

    Pike,

    Thanks for the response. I understand I can do it manually, but I was trying to see if there was an easy way to do it via a VBA code. At the end of the day I will need to email certain specific tabs to certain people within the organization for which I already have an idea of how to do via a VBA code. This consolidation of tabs is just the first step so that I can get them all on the same workbook which will enable me to use a script to tell VBA to grab "x" tabs and send it to "y" people. I know I can use this code to move sheets within the same workbook, but how would I move or copy it to another workbook: ActiveSheet.Move after:=Worksheets(Worksheets.Count)

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Copying a range of tabs in one file to the end of another file

    Hi som3on3_10,
    I was think you could use/modify something like kris userform to select and then copy the sheets to a new workbook
    Attached Files Attached Files

+ 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