+ Reply to Thread
Results 1 to 4 of 4

Consolidate Data multiple sheets to a summary sheet

  1. #1
    Registered User
    Join Date
    03-20-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Consolidate Data multiple sheets to a summary sheet

    I know this should be simple and there are multiple examples of various versions of compiling data from multiple sheets to a summary sheet.

    However, what I would like to do is simply copy the data from approximately 11 sheets to a summary sheet; I would like to add the name of each sheet in the last column (L) correlated with the copied data.

    I have the code, but I’m not able to get it to run and when I do a compile in Visual Basic I get a “Compile Error – Next without For”. I have a For: “For Each sh In ThisWorkbook.Worksheets” so I’m not sure what I’m missing.

    Please see attached example sheet to see the workbook and the code that I have.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Consolidate Data multiple sheets to a summary sheet

    you're missing an End If. you open three ifs but only close two of them.
    Hope I could help - if your post has been solved don't forget to mark it as such.

    Clicking the * below is a great way to say thanks!

    "Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito

  3. #3
    Registered User
    Join Date
    03-20-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Re: Consolidate Data multiple sheets to a summary sheet

    Thank you so much. It works perfect.

  4. #4
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Consolidate Data multiple sheets to a summary sheet

    glad i could help - sometimes a second pair of eyes works wonders

+ 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: 6
    Last Post: 06-05-2014, 04:40 AM
  2. Macro to PRIORITISE and CONSOLIDATE data across different sheets into summary sheet
    By JamesGoulding85 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2013, 07:49 AM
  3. Replies: 20
    Last Post: 06-20-2013, 09:04 AM
  4. Replies: 20
    Last Post: 10-19-2012, 04:35 PM
  5. Consolidate data from rows in many sheets to summary sheet?
    By Dynelor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2008, 07:34 PM

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