Results 1 to 2 of 2

Thread: Consolidation (Sum up all values from multiple worksheets to one worksheet)

  1. #1

    Question Consolidation (Sum up all values from multiple worksheets to one worksheet)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I am very new in VBA coding. Recently was assigned a task by my boss to do up a coding for easy consolidation for their profit and loss budget. the problem is that they have around 80+ outlets to do consolidation for. Each outlet's profit and loss is in different workbook itself. He wanted a workbook where it will transfer all the data into one workbook, with a summary worksheet. He also want to be able to select the outlets he wish to consolidate through a home worksheet where he just need to check the checkboxes for the outlets, and the master sheet would then automatically reflect the sum up figures for the selected outlets. He used to do this manually by copy and pasting and manually linking the cells across.

    He would now want it to be more automated, and preferably through the use of macro to do it. I managed to find the code to transfer the respective worksheets for the 80 workbooks into one workbook under different tabs. However, since not all files are received at our side yet, I hope that someone out there could help me out in the coding for the consolidation part (master worksheet) where it would reflect the selected outlet's (selection is done in home tab) summed up figures (all worksheets have the same format). Is there a way to link the checkboxes to the respective worksheets? Perhaps through matching the code to the sheet name and then to the summary sheet?

    Would really appreciate all the help given. Thank you!
    Attached Files Attached Files

  2. #2
    Acolyte jaslake's Avatar
    Join Date
    Aug 2011
    Location
    mineral city oh usa
    Posts
    81
    Articles
    0
    Excel Version
    2007;2010;MAc2011
    Hi paperlurve

    This Forum (and most others) discourage Cross Posting. If you must, please inform us you've done so.

    http://www.excelguru.ca/forums/showt...-one-worksheet)

    http://www.ozgrid.com/forum/showthread.php?t=195360

    Crossposting etiquette is explained here http://www.excelguru.ca/content.php?184
    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •