Combining Multiple Worksheets and/or Multiple Workbooks

Discussion in 'Mac Apps and Mac App Store' started by bosstone75, Feb 1, 2010.

  1. bosstone75 macrumors newbie

    May 24, 2009

    I've searched around and I'm having difficulty finding an answer for what I would think would be a relatively simple and common problem.

    I have a user who has created multiple worksheets AND multiple workbooks with multiple worksheets (don't ask me why).

    All the worksheets have exactly the same columns headings, so I could do a copy and paste, but I would have to do that for a hundred different worksheets.

    2 questions...

    Is there a quick and easy way to basically copy and paste all of the information currently contained in multiple worksheets into one worksheet?


    Is there a way to do the same thing across multiple workbooks? If you can only answer question one, it wouldn't be hard for me then to manually cut and paste across workbooks once I have the worksheets combined.

    I haven't had any experience with Macros or VBA, so if you talk about that, I'll need a bit of extra support.

  2. GGJstudios macrumors Westmere


    May 16, 2008
    You haven't said what operating system you're running: Mac OS X or Windows.
    You haven't said what application you're using: MS Excel or Numbers.
    You haven't said which version you're running.
  3. bosstone75 thread starter macrumors newbie

    May 24, 2009
    Sorry and thanks.

    I'm on a Mac 10.5.4
    I'm using Excel 12.2.3 (version 2008)
  4. GGJstudios macrumors Westmere


    May 16, 2008
    Excel 2008 doesn't support VBA or macros, so you'll have to do it manually.

Share This Page