Combining data from several worksheets

[Johnny T]

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.

[Nick Hodge]

Johnny

You could try Data>Consolidate...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Johnny T" <Johnny T@discussions.microsoft.com> wrote in message
news:CA9765FB-DAB7-4778-8DC0-C94DE6E91DEC@microsoft.com...
> 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.

[Johnny T]

Thanks Nick. However, the big operator in my question is "newbie".
Data>Consolidate 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 Data>Consolidate...
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Johnny T" <Johnny T@discussions.microsoft.com> wrote in message
> news:CA9765FB-DAB7-4778-8DC0-C94DE6E91DEC@microsoft.com...
> > 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.
>
>
>

[Ron de Bruin]

Try
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Johnny T" <JohnnyT@discussions.microsoft.com> wrote in message news:D3B56A55-0061-402F-AEEF-64395380D0A3@microsoft.com...
> Thanks Nick. However, the big operator in my question is "newbie".
> Data>Consolidate 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 Data>Consolidate...
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>>
>>
>> "Johnny T" <Johnny T@discussions.microsoft.com> wrote in message
>> news:CA9765FB-DAB7-4778-8DC0-C94DE6E91DEC@microsoft.com...
>> > 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.
>>
>>
>>

[Nick Hodge]

Johnny

Excel's Help explains this quite well. (Enter consolidate, you will find
several help articles to help you along.

The other thing you can do is go to you 'totalling' sheet and enter an = in
the top left cell and if you simply want to add them enter SUM and a bracket
(.

Now click on your first sheet in the same cell as your 'totalling sheet',
say A2. and, with the shift key held down, click on your last sheet in the
same cell.. You will end up with a formula like. (Don't forget to close the
bracket)

=SUM(Sheet1Sheet10!A2)

This is effectively what consolidate does. You can use just about any
function, SUM, COUNT, AVERAGE, etc.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Johnny T" <JohnnyT@discussions.microsoft.com> wrote in message
news:D3B56A55-0061-402F-AEEF-64395380D0A3@microsoft.com...
> Thanks Nick. However, the big operator in my question is "newbie".
> Data>Consolidate 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 Data>Consolidate...
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>>
>>
>> "Johnny T" <Johnny T@discussions.microsoft.com> wrote in message
>> news:CA9765FB-DAB7-4778-8DC0-C94DE6E91DEC@microsoft.com...
>> > 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.
>>
>>
>>