+ Reply to Thread
Results 1 to 5 of 5

How do you combine data from 5 sheets to 1 sheet?

  1. #1
    Registered User
    Join Date
    05-31-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    88

    How do you combine data from 5 sheets to 1 sheet?

    I have 1 workbook with 5 sheets.

    What I want to do is combine all these data to 1 sheet.

    How will I do that with Macro?

    Columns in all my sheets are identical

    My columns are
    PHP Code: 
    A          B        C        D         E         F
    Market     Desc     Local   Profile   Item   Inventory Quantity 
    Thanks!
    Last edited by geng; 06-09-2010 at 08:56 PM.

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: How do you combine data from 5 sheets to 1 sheet?

    You will have to explain better what you want. Do you want to add all cells A1 together. Do you just want to create a copy of each worksheet in the 5 files in the summary workbook? Or what?
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

  3. #3
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How do you combine data from 5 sheets to 1 sheet?

    Hi geng

    If you wish to append the data from all worksheets into a master worksheet, see this thread http://www.excelforum.com/excel-prog...one-sheet.html

    In you want to
    add all cells A1 together
    then look at this link http://www.excel-it.com/workbook_downloads.htm

    Hope this helps.

    John
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How do you combine data from 5 sheets to 1 sheet?

    The macro I have posted here does what you want, possibly with minimal editing. Set the SortStr to "Market" if you want to sort the data by the first column on the master sheet once it is merged.

  5. #5
    Registered User
    Join Date
    05-31-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: How do you combine data from 5 sheets to 1 sheet?

    Thanks to all of you guys for finding time to help!

    And Jerry, your code was perfect! Thank you so much!!!

+ 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