As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

[SOLVED ]Excel Help, Merging Worksheets

CorvusCorvus .VancouverRegistered User regular
edited June 2009 in Help / Advice Forum
Alright, I feel like an idiot as I'm sure I should know how to do this, but I have some excel workbooks with multiple worksheets where I just need to do a simple merge of all the sheets into one. So, help please. I need to copy everything, including column and row headings.

Thanks.

Edit: Solved!

:so_raven:
Corvus on

Posts

  • Options
    -Phil--Phil- Registered User regular
    edited June 2009
    1 - Open both workbooks.

    2 - highlight all of the sheets (using ctrl or shift button) that you wish to transfer.

    3 - Right click one of the sheets and select Move or Copy option

    4 - Select the new book on top. Press OK. (You can also select to just send a copy)

    5 - ???

    6 - Profit

    -Phil- on
    [SIGPIC][/SIGPIC]
  • Options
    CorvusCorvus . VancouverRegistered User regular
    edited June 2009
    Am I missing something? That just seems to copy the worksheets. I might not have been clear, I actually need to merge all the worksheets into one sheet, and I have multiple workbooks I need to do this in, but I won't be merging the workbooks.

    Corvus on
    :so_raven:
  • Options
    -Phil--Phil- Registered User regular
    edited June 2009
    No, I interpreted what you were asking for incorrectly.

    The only way I know of this is maybe copying the rows by highlighting them one the left then pasting them into the new worksheet below the current information you have (Highlight columns if your putting the new information to the right of the current information).

    -Phil- on
    [SIGPIC][/SIGPIC]
  • Options
    DJ-99DJ-99 Registered User regular
    edited June 2009
    Yeah, what do you mean by "merge"? Do you have 10 columns in each, and you want to make it 20 columns? Or do you have 50 rows in each, and you want to make it 100 rows, or what?

    I don't understand why you can't just use a simple copy/paste function.

    DJ-99 on
  • Options
    CorvusCorvus . VancouverRegistered User regular
    edited June 2009
    DJ-99 wrote: »
    Yeah, what do you mean by "merge"? Do you have 10 columns in each, and you want to make it 20 columns? Or do you have 50 rows in each, and you want to make it 100 rows, or what?

    I don't understand why you can't just use a simple copy/paste function.

    Basically, I want all the data from 20+ worksheets within a workbook merged into one worksheet. And I have multiple files I need to do this in, so copy and pasting is going to be both tedious.

    Anyhow, I think this macro I found basically does what I need to do:

    http://www.mrexcel.com/archive/VBA/17846.html

    Corvus on
    :so_raven:
  • Options
    ArikadoArikado Southern CaliforniaRegistered User regular
    edited June 2009
    Is vlookup out of the question?

    Arikado on
    BNet: Arikado#1153 | Steam | LoL: Anzen
  • Options
    CorvusCorvus . VancouverRegistered User regular
    edited June 2009
    Arikado wrote: »
    Is vlookup out of the question?

    This begs the question, what's vlookup? :P

    I should mark this as solved though, the macro I posted the link to did what I needed.

    Corvus on
    :so_raven:
Sign In or Register to comment.