+ Reply to Thread
Results 1 to 3 of 3

Exclamation Collate data from varying number of sheets to one sheet

  1. #1
    Registered User
    Join Date
    11-22-2009
    Location
    Newcastle,England
    MS-Off Ver
    Excel 2003
    Posts
    78

    Exclamation Collate data from varying number of sheets to one sheet

    Hi people


    Have some code I have found from this site shown below. It works great however I need some help in editing it to change what it does. Basically the code currently takes all the data from set cells from all sheets after a set point and adds a new sheet and copies data from each of the sheets between this point and the new sheet and then pastes it to this final sheet.

    What I wish to change is I already have a sheet which I will be using to analyse data from so how would the code look to be able to point to such a sheet within the same workbook? The sheet will be within the first 2 sheets of the workbook so from the code below you can see I have already set it to not include this sheet. I wont be needing a new sheet to be created at the end, I just want the data to paste to my analysis sheet which we can call "analysis".

    Please Login or Register  to view this content.
    Thanks for any help
    Last edited by munkee; 11-28-2009 at 06:08 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Exclamation Collate data from varying number of sheets to one sheet

    Hello munkee,

    This version of the macro lets you specify the worksheet you want to use as the summary sheet. In the code, I used the worksheet name "Analysis". You can also specify by name which worksheets you want to exclude. I used the names "Sheet1" and "Sheet2". Change these to what you will be using.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-22-2009
    Location
    Newcastle,England
    MS-Off Ver
    Excel 2003
    Posts
    78

    Re: Exclamation Collate data from varying number of sheets to one sheet

    perfect thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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