+ Reply to Thread
Results 1 to 6 of 6

sum totals of files in folder on one worksheet

  1. #1
    Registered User
    Join Date
    07-15-2019
    Location
    USA
    MS-Off Ver
    365
    Posts
    19

    sum totals of files in folder on one worksheet

    i have atleast 90-100 files monthly in one folder that i would like to automatically total the amount of certain cells. all the files have the same structure and info is located in the same area. For example on the file i have attached i would like to have a worksheet that is exactly that but totals all the numbers from each of the files in a specific folder. I hope i have made sense in what I'm asking, I've searched and tried a couple of things but cannot seem to get it to work.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: sum totals of files in folder on one worksheet

    Which data needs to be totalled? What do you want the summary to look like. Provide some realistic samples that we can work with. No pictures, please.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-15-2019
    Location
    USA
    MS-Off Ver
    365
    Posts
    19

    Re: sum totals of files in folder on one worksheet

    The totals in the highlighted table from column Z:AR down to the rows Z7:z35 pretty much that whole table i would like to have on a separate file alone and total the amounts from each of the files in the monthly folder.
    I uploaded an example of what i would need the monthly total sheet to look like. Thank you for your help on this
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: sum totals of files in folder on one worksheet

    You have shown only one file. What would multiple files look like in your master. Are you appending each to the other? Consolidating? You have not given us any explanation of what is in your head. We can only guess at what you are looking to achieve. Help us here with a realistic demo. You have 90-100 files, yet you show us what happens with one and not many.

  5. #5
    Registered User
    Join Date
    07-15-2019
    Location
    USA
    MS-Off Ver
    365
    Posts
    19

    Re: sum totals of files in folder on one worksheet

    For example at the end of the month I would end up with around 90 files that exactly like the file named 7 15 19 RO DL.xlsm. The data that I’m interested to combine is the counts that are the table that I highlighted on that file. If possible I would like to use a file like the Monthly Totals files I uploaded and combine the counts on there.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: sum totals of files in folder on one worksheet

    I understand your explanation but, I really do need to see a demo file with real numbers so that I can understand exactly what you say you are combining and how. If you are unwilling to demonstrate with an example with sample numbers, then you can hope someone else can read your mind because I am finished trying to help. I have asked for a realistic demo file several time now and you have ignored that.

+ 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. [SOLVED] Looping Through Txt Files in Folder and Pasting Contents to Worksheet
    By bruppert in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-07-2019, 04:31 PM
  2. Replies: 1
    Last Post: 01-28-2019, 06:55 PM
  3. VBA multiple files from folder to master worksheet next available row
    By MP1989 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-06-2018, 04:42 AM
  4. How to copy files names from a folder to a worksheet.
    By excelsos in forum Excel General
    Replies: 3
    Last Post: 11-13-2017, 02:00 PM
  5. Copying a row from multiple files in a folder and add them to a new worksheet
    By elderL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2014, 04:54 AM
  6. Merging multiple excel files in a folder into one master worksheet in a new worksheet
    By johnny_canuck in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-22-2013, 12:20 PM
  7. Replies: 1
    Last Post: 06-23-2006, 04:25 PM

Tags for this Thread

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