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

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.