This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/consol.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm

The "Bread-Roll" consolidation method - great for accountants. See how
simple it is to consolidate any combination of your organisation's accounts.
(No VBA used)


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"NoviceIan" <NoviceIan@discussions.microsoft.com> wrote in message
news:B2CB04EA-8E5A-4374-8EFE-D6D37A3001A1@microsoft.com...
> Hi all,
>
> I have several seperate spreadsheets all in the same format and I was
> wondering if it would be possible to create another to total up the
contents
> of the current lot. Is this possible?
>
> It has to be a seperate spreadsheet to avoid unnecessary complication for
> other staff.
>
> Thanks Ian