+ Reply to Thread
Results 1 to 5 of 5

merge data and summing values for across multiple sheets

  1. #1
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    280

    merge data and summing values for across multiple sheets

    hi
    I need macro not PQ to merge the data and summing values from multiple sheets , starts from JAN to DEC to sheet RESULT when compare the data among all of sheets except sheet RESULT , it should match three columns B,C,D , it's different in COL D then bring all of data and summing the values in last column in sheet RESULT
    keep in your mind this is a sample but my real data for each sheet contains at least 3000 rows
    thanks in advance
    Attached Files Attached Files
    Last edited by Alaa-A; 05-31-2021 at 06:24 AM.

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

    Re: merge data and summing values for across multiple sheets

    This should work if the local month names are English.
    Please Login or Register  to view this content.
    Last edited by jindon; 05-31-2021 at 06:42 AM.

  3. #3
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    280

    Re: merge data and summing values for across multiple sheets

    brilliant ! this is exactly what I want
    just I want bold the headers and highlight by blue color in sheet result also formatting the data in center
    Last edited by Alaa-A; 05-31-2021 at 06:51 AM.

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

    Re: merge data and summing values for across multiple sheets

    Cange
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    280

    Re: merge data and summing values for across multiple sheets

    thanks so much
    just curiosity if the sheets name's are not month just any names
    how become this line
    HTML Code: 
    Last edited by Alaa-A; 05-31-2021 at 07:47 AM.

+ 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] Summing the values from multiple sheets with date condition
    By rishiambekar in forum Excel General
    Replies: 9
    Last Post: 04-30-2020, 08:22 AM
  2. [SOLVED] Merge multiple sheets data into one worksheet based on multiple criteria and date
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-03-2018, 04:19 AM
  3. Replies: 1
    Last Post: 06-09-2016, 05:10 PM
  4. Summing values in named ranges based on dates, multiple sheets!
    By giggsteve8 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2013, 01:42 PM
  5. Summing data record from multiple sheets
    By avk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-11-2013, 09:17 AM
  6. Summing data from multiple sheets and dropdown lists
    By Skwerl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2011, 08:00 PM
  7. Summing Values accross multiple sheets
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2009, 05:17 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