Save a worksheet from workbook
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Save a worksheet from workbook

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Jeddah,Saudi Arabia
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a workbook with about 45 worksheets. If I need to save a certain worksheet to another workbook, I used to save the whole workbook with new name and delete the worksheets that I don't need. Is there another way to do it?

    Thanks,
    Ernie

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To do it just create the new workbook, rightclick on the sheet tab that you want, and select 'Move or Copy'

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yeah, :
    1.right click the worksheet you want to save by itself
    2. click move or copy
    3. under drop down menu "to book" select "(new book)".

    then you have that sheet in a different book. If you check the copy box, it will copy it to a new book, but leave the original in your big file.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could click Edit, Move or Copy Sheet and select New Book from the first drop down box. Make sure you tick the Create a Copy checkbox as well.

    HTH,
    D

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Jeddah,Saudi Arabia
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks to all you guys.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com