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.
>>
>>
>>