+ Reply to Thread
Results 1 to 2 of 2

Sum from multiple workbooks

  1. #1
    Registered User
    Join Date
    06-23-2014
    Location
    Penang, Malaysia
    MS-Off Ver
    2007
    Posts
    2

    Unhappy Sum from multiple workbooks

    Hi all, i'm newbie here..

    My problem:
    - how to auto sum from many files at same folder ex: :C\Account and inside the folder got 150 files with .xlsx format and all files are the same format as picture.
    - It's mean, when i change the data from the files, its will auto update at my new file. ex: master.xlsx
    - FYI, the data range need to SUM is (D8:L35)

    Sorry if wrong threads post and appreciate from all of you to help me.. Thanks guys..
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    06-23-2014
    Location
    Penang, Malaysia
    MS-Off Ver
    2007
    Posts
    2

    Re: Sum from multiple workbooks

    add info:

    - every file got 2 sheets. ORDER & RECEIPT. ORDER is a sheet1 & RECIEPT is a Sheet2. The values that need to SUM are from ORDER sheet.

    Thanks.

+ 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. Macro to Pull Data from Multiple Workbooks to One Master Workbooks
    By eranajoy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2019, 09:24 AM
  2. Replies: 6
    Last Post: 02-28-2014, 09:34 AM
  3. Replies: 20
    Last Post: 03-13-2013, 04:15 PM
  4. [SOLVED] Open Multiple Workbooks, Record names, Copy paste to Active Workbook, Close the Workbooks
    By vba_madness in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2013, 06:09 AM
  5. split Workbooks to multiple workbooks with multitabs
    By xanto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2010, 06:47 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