+ Reply to Thread
Results 1 to 6 of 6

how to add multiple workbooks in one excel file

Hybrid View

  1. #1
    Registered User
    Join Date
    06-10-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    3

    how to add multiple workbooks in one excel file

    Hello experts,

    I am new bee to this forum if any mistakes please excuse..

    i want multiple workbooks in one excel file, i googled a lot but no luck, please have a look of attachment i want to create the same..
    any help is appreciated

    thanks in advance
    jannapu
    Attached Images Attached Images

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: how to add multiple workbooks in one excel file

    a workbook IS a file, perhaps you meant that you want to add multiple workSHEETS to a workbook? if you meant you wanted more worksheets, shift-F11 will add a new sheet. if this is not what you wanted, please help us to understand better
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-10-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: how to add multiple workbooks in one excel file

    Thank you for your reply..

    please have a look of attachment...in bottom, that is a screen shot and in modified with the help of ms paint to better understand for what ia am looking for.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: how to add multiple workbooks in one excel file

    ok, so that does look like a bunch of cascaded workbooks. can you not just go to "office"/new/blank workbook. what are you trying to do?

  5. #5
    Registered User
    Join Date
    06-10-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: how to add multiple workbooks in one excel file

    am not able find the /office/new/blank tab.......can you provide some more info

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: how to add multiple workbooks in one excel file

    its the round button in the very top left corner of the excel workbook

+ 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