+ Reply to Thread
Results 1 to 3 of 3

Consolidating data from multiple workbooks into a separate workbook

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    67

    Talking Consolidating data from multiple workbooks into a separate workbook

    Hello,

    I currently have an issue which I'm struggling with and was wondering what's the best way of tackling this problem.

    I have multiple workbooks that go by product and month that are continuously being updated with new information (so new rows are being added on a regular basis), e.g.

    Product_A_July_2013.xlsx
    Product_B_July_2013.xlsx
    Product_C_July_2013.xlsx
    Product_A_August_2013.xlsx
    Product_B_August_2013.xlsx
    Product_C_August_2013.xlsx

    Essentially, what I need to be able to do is collate information from all those workbooks into a separate workbook. So, I'd like to have a pivot table which sources data from the above spreadsheets combined.

    I'm thinking the best way of doing this is to find a way of automatically copying the worksheets from those workbooks into a single worksheet in a separate workbook. The only issue is that, the workbooks listed above are continuously being updated, i.e. new rows are constantly being added. Also, at the start of a new month, new spreadsheets are going to have to be included, e.g. September, October, November, etc.

    I hope that all made sense. I'm still a beginner in VBA and so I'm not too sure if this is possible to do. Any advice or thoughts on how I could tackle this problem would be appreciated?

    Thank you

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Consolidating data from multiple workbooks into a separate workbook

    can you please attached sample excel workbook, its make very easy to resolve ur query
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Registered User
    Join Date
    02-21-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Consolidating data from multiple workbooks into a separate workbook

    Quote Originally Posted by Naveed Raza View Post
    can you please attached sample excel workbook, its make very easy to resolve ur query
    I've attached a copy of the spreadsheets just as an example of what I'm trying to achieve.

    Consolidated.xlsx
    Product_A_August_2013.xlsx
    Product_B_August_2013.xlsx
    Product_C_August_2013.xlsx

    I would like the consolidated spreadsheet to update based on the Product spreadsheet.

    My only concern is how I would manage this spreadsheet as the months go on, because I would have to include, September, October, November, etc in this spreadsheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Consolidate data range from multiple workbooks into a separate workbook
    By 3xcx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2013, 11:45 AM
  2. Consolidating data from Multiple Workbooks to One Workbook issue
    By jeffvnz in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-23-2012, 07:13 PM
  3. Consolidating data from multiple workbooks into Master Workbook
    By zloywolf in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-14-2012, 10:26 AM
  4. Copy Data From Multiple Open Workbooks to Another Workbook with Separate Worksheets
    By lupitenis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2012, 05:36 PM
  5. consolidating data from multiple workbooks
    By adams20071 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2010, 06:26 PM

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