Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining data from several worksheets
Sorry for the newbie question, but. . .I have data in a workbook on 10
worksheets. All are formatted identically, and I would like to combine the 10 worksheets into a master worksheet--number 11. How can I do this without having to go in and cut and paste? thanks for your help. |
#2
|
|||
|
|||
Johnny
You could try DataConsolidate... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Johnny T" <Johnny wrote in message ... Sorry for the newbie question, but. . .I have data in a workbook on 10 worksheets. All are formatted identically, and I would like to combine the 10 worksheets into a master worksheet--number 11. How can I do this without having to go in and cut and paste? thanks for your help. |
#3
|
|||
|
|||
Thanks Nick. However, the big operator in my question is "newbie".
DataConsolidate seems likely, of course, but nothing that comes up after making that selection makes sense. I'm not an MVP, jsut a newbie. Which function, what source, etc. . .? Anybody out there willing to be a bit more explicit and thorough? "Nick Hodge" wrote: Johnny You could try DataConsolidate... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Johnny T" <Johnny wrote in message ... Sorry for the newbie question, but. . .I have data in a workbook on 10 worksheets. All are formatted identically, and I would like to combine the 10 worksheets into a master worksheet--number 11. How can I do this without having to go in and cut and paste? thanks for your help. |
#4
|
|||
|
|||
Try
http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Johnny T" wrote in message ... Thanks Nick. However, the big operator in my question is "newbie". DataConsolidate seems likely, of course, but nothing that comes up after making that selection makes sense. I'm not an MVP, jsut a newbie. Which function, what source, etc. . .? Anybody out there willing to be a bit more explicit and thorough? "Nick Hodge" wrote: Johnny You could try DataConsolidate... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Johnny T" <Johnny wrote in message ... Sorry for the newbie question, but. . .I have data in a workbook on 10 worksheets. All are formatted identically, and I would like to combine the 10 worksheets into a master worksheet--number 11. How can I do this without having to go in and cut and paste? thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Pivot Tables - Summarising data from 100,000 rows | Excel Discussion (Misc queries) | |||
Summarizing Data across Worksheets using a single reference | Excel Worksheet Functions | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Calculate data on 2 different worksheets | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |