+ Reply to Thread
Results 1 to 3 of 3

VBA to add numbers in columns from various workbooks

  1. #1
    Registered User
    Join Date
    04-24-2020
    Location
    JHB, South Africa
    MS-Off Ver
    2016
    Posts
    2

    VBA to add numbers in columns from various workbooks

    Mark from South Africa. Trust you and the family are keeping safe during the COVID-19 situation.

    I have 1 master workbook, namely: “Example_FC 2020_Master” with 1 tab called “Master” and then I have 2 excl workbooks, namely:
    “Example_FC 2020_Retail_Mark” and “Example_FC 2020_Retail_Peter”, each with a master tab and then various customer name tabs.

    The worksheets consist of products.

    The idea is to forecast per customer, per product. In the master tab of “Example_FC 2020_Retail_Mark” and “Example_FC 2020_Retail_Peter”, I have used vlookup (very basic), to add all the columns from the various tabs in the same workbook, per product to give a grant total per month (all customers forecast quantities added together per product).

    I am sure it is earier to use VBA, than vlookup, but thats for another day.

    What I need is the following.....
    I would like to have a button in the “Example_FC 2020_Master” workbook, that I can press and what it will do is:
    Look (in a specific folder say on my desktop for example), at the 2 excl workbooks namely: “Example_FC 2020_Retail_Mark” and “Example_FC 2020_Retail_Peter”, in their master tabs and extract the quantities, per product and add them togther in the “Example_2020_Master” workbook.
    I will eventually have about 10 different workbooks with about 300 products, all exactly the same as “Example_FC 2020_Retail_Mark” and “Example_FC 2020_Retail_Peter” all consolidating to the “Example_FC 2020_Master”

    Can someone help me with the code if possible? Example attached - Willing to donate to a charity for assistance.

    "I have posted on 2 other forums"
    Last edited by NewbieMark; 04-24-2020 at 05:36 AM. Reason: Add comment

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,463

    Re: VBA to add numbers in columns from various workbooks

    Assuming Sheet name for each workbook come from Workbook name.
    e.g
    Example_FC 2020_Retail_Mark.xlsm‎ ---> Retial Mater
    Example_FC 2020_Trade_Peter.xlsm‎ ---> Trade Master

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-24-2020
    Location
    JHB, South Africa
    MS-Off Ver
    2016
    Posts
    2

    Re: VBA to add numbers in columns from various workbooks

    Thank you so much jindon. WOW. I cant wait to learn......Will give it a try

+ 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. Identification of duplicate numbers and missing numbers in multiple columns
    By kswapnadevi in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-18-2018, 11:50 AM
  2. Replies: 1
    Last Post: 05-04-2016, 02:29 PM
  3. [SOLVED] 2 separate columns with numbers separated by commas and single numbers not, need sum
    By Slothbob in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2013, 04:33 PM
  4. Replies: 6
    Last Post: 01-07-2013, 08:58 PM
  5. Replies: 1
    Last Post: 08-07-2012, 07:47 PM
  6. Sequential numbers in different workbooks
    By vpatel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2007, 11:06 AM
  7. ADODB.Recordset from workbooks : numbers only?
    By JVLin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2006, 12:00 AM

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