Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating multiple worksheets into one.
I need to do a piece of analysis across several worksheets in the same
workbook but in order to do it I need a quick and easy way to pull all of the information into a new, single sheet (preferably as the first sheet in the workbook but that bit isn't essential.) All of the spreadsheets contain the same data structure - so data is held in columns A thru U, but the number of rows will vary wildly and the number of sheets in the workbook will change from time to time. Is there some sort of macro I could produce that would analyse the number of worksheets and then pull all of the information out of those sheets into a new one? Or is that an impossible ask? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating multiple worksheets into one.
Hi
I posted a possible solution to this same question by you at 16:52 on 16/10/06. Did that not work? -- Regards Roger Govier "Bovine Jones" wrote in message ... I need to do a piece of analysis across several worksheets in the same workbook but in order to do it I need a quick and easy way to pull all of the information into a new, single sheet (preferably as the first sheet in the workbook but that bit isn't essential.) All of the spreadsheets contain the same data structure - so data is held in columns A thru U, but the number of rows will vary wildly and the number of sheets in the workbook will change from time to time. Is there some sort of macro I could produce that would analyse the number of worksheets and then pull all of the information out of those sheets into a new one? Or is that an impossible ask? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating multiple worksheets into one.
Gotta love the technology! When I tried posting the question yesterday I got
an error message telling me it couldn't be posted and to try again later. I'll head over there now and have a look. Thanks Roger. "Roger Govier" wrote: Hi I posted a possible solution to this same question by you at 16:52 on 16/10/06. Did that not work? -- Regards Roger Govier "Bovine Jones" wrote in message ... I need to do a piece of analysis across several worksheets in the same workbook but in order to do it I need a quick and easy way to pull all of the information into a new, single sheet (preferably as the first sheet in the workbook but that bit isn't essential.) All of the spreadsheets contain the same data structure - so data is held in columns A thru U, but the number of rows will vary wildly and the number of sheets in the workbook will change from time to time. Is there some sort of macro I could produce that would analyse the number of worksheets and then pull all of the information out of those sheets into a new one? Or is that an impossible ask? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding and Naming Multiple Worksheets | Excel Worksheet Functions | |||
Consolidating multiple worksheets | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Update multiple worksheets | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |