LINKING TOGETHER FOR TOTAL

[Caroline7361]

I would like to know how to create a summary sheet for a workbook, for
example if I create worksheets for 3 branches of a company with the same
headings and formulas, how do I do a total summary sheet for all three
together?

[Dave]

Caroline

I don't know if this is available in the version of Excel you are using but
in Excel 2003 try Consolodate on the Data manu.

Dave
"Caroline7361" <[email protected]> wrote in message
news:[email protected]...
>I would like to know how to create a summary sheet for a workbook, for
> example if I create worksheets for 3 branches of a company with the same
> headings and formulas, how do I do a total summary sheet for all three
> together?

[Caroline7361]

Hi Dave, thanks for the reply. I have had a look and it is on it but I still
don't know how to use it. Can you advise please?

"Dave" wrote:

> Caroline
>
> I don't know if this is available in the version of Excel you are using but
> in Excel 2003 try Consolodate on the Data manu.
>
> Dave
> "Caroline7361" <[email protected]> wrote in message
> news:[email protected]...
> >I would like to know how to create a summary sheet for a workbook, for
> > example if I create worksheets for 3 branches of a company with the same
> > headings and formulas, how do I do a total summary sheet for all three
> > together?
>
>
>