+ Reply to Thread
Results 1 to 6 of 6

VBA: Concentrating data from many sheets to a summarizing sheet

  1. #1
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    VBA: Concentrating data from many sheets to a summarizing sheet

    Hi everyone,
    I explain what the code should do in the excel..
    Basically I am trying to concentrate data from many sheets to a summarizing sheet.
    Thanks in advance!
    Please * if you like the answer

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,168

    Re: VBA: Concentrating data from many sheets to a summarizing sheet

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 09-15-2020 at 06:50 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: VBA: Concentrating data from many sheets to a summarizing sheet

    @sintek - thanks a lot for the code! now I need to implement the code on the real file. One thing - in "summary", range H5:I5 (in green), interest data from "Plant 4" has not been transfered to "summary".
    Attached Files Attached Files

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,168

    Re: VBA: Concentrating data from many sheets to a summarizing sheet

    Replace these to snippets...
    Please Login or Register  to view this content.
    With
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: VBA: Concentrating data from many sheets to a summarizing sheet

    Works great. Thank you.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,168

    Re: VBA: Concentrating data from many sheets to a summarizing sheet

    .........................
    THANKS.gif

+ 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. Replies: 11
    Last Post: 03-29-2019, 06:53 PM
  2. [SOLVED] Need help summarizing data from different sheets into one sheet
    By Toyphoon65 in forum Excel General
    Replies: 3
    Last Post: 10-09-2015, 09:50 AM
  3. Summarizing data from 60 sheets
    By Perrinho in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2014, 12:31 PM
  4. Replies: 6
    Last Post: 03-05-2014, 11:48 PM
  5. Summarizing data from multiple sheets into one sheet
    By Irish Pat in forum Excel General
    Replies: 10
    Last Post: 09-09-2011, 03:58 PM
  6. Summarizing data over several sheets
    By Dowler in forum Excel General
    Replies: 18
    Last Post: 05-12-2009, 09:21 AM
  7. Concentrating several sheets in one master sheet
    By 1976petter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2006, 08:55 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