+ Reply to Thread
Results 1 to 3 of 3

How do you copy and move all worksheets to a new file

  1. #1
    Registered User
    Join Date
    05-12-2013
    Location
    Utah
    MS-Off Ver
    Excel 2003
    Posts
    33

    How do you copy and move all worksheets to a new file

    I want to copy all 25 worksheets to a new file and don't know how to do this easily.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: How do you copy and move all worksheets to a new file

    If your workbook consists of just the 25 sheets then you can do a save as and create a new workbook.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: How do you copy and move all worksheets to a new file

    assume you know how do do it for one sheet with the move or copy feature

    if your workbook has more than 25 sheets, you can press CTRL + left click every sheet you want to move/copy
    after you have selected all that you want you can right click (on the sheetname) and select move or copy

    alternatively you can select and delete every other sheet that you dont want and use alans SAVEAS method mentioned above
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. VBA to move/make a copy of excel file.
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2014, 10:21 AM
  2. VBA move multiple and selected sheets/tabs to new file and copy file as value
    By NeilM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2013, 06:19 AM
  3. [SOLVED] Move/Copy worksheets (possibly) using vlookups
    By daniel_t in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-09-2013, 11:56 AM
  4. rename & copy *.xls file in the folder then move
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-13-2011, 12:22 PM
  5. How to disable copy or Move function of sheets,worksheets ?
    By vumian in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-23-2008, 02:03 AM

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