+ Reply to Thread
Results 1 to 1 of 1

Help to sum value from multiple workbook

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver

    Help to sum value from multiple workbook

    Hi all:

    I have a lot source workbooks like COVID19-aaaaaaaa-bbbbbb-PLAll.xlsx, each source file have some sheets like: PL01, PL02 ....

    Now I want macro to sum all value from source file to file TOTAL.slsx like:
    - Sum all source sheets(PL01).range("C9:J36","I38") to TOTAL file, sheet PL01.range("C9:J36","I38")
    - Sum all source sheets(PL02).range("B6:I10") to TOTAL file, sheet PL02.range("B6:I10")

    I try hard to code and have code like belove, each code will sum each sheet(PL0xx). Code work well but very slow It's take me 247 seconds for 156 files each source sheets, Please help me improve code faster or have another code to do.

    My code belove:
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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