Tying Several Worksheets Together in One Worksheet

[strawberryangel83]

Ok. I have done 3 worksheets with formulas in them. My boss now wants me to
have it to where there is a master worksheet, with the others conjoined to it.

the main worksheet will be the master account with the total of all expense
accounts. the others are for other workers and their expense accounts, which
they all add up to the totals on the main sheet.

i hope i did not confuse you!

 

[Pete_UK]

In your master sheet you could have a formula like this:

=Sheet1!A1 + Sheet2!A1 + Sheet3!A1

to add all the A1 cells from those 3 sheets together. You can simplify
this as:

=SUM(Sheet1:Sheet3!A1)

assuming there is only the Sheet2 tab between the Sheet1 and Sheet3
tabs in your file.

That is one way of combining the data together from 3 separate sheets.
However, you might want to show the individual totals from the 3
sheets, so you need to give us a few more details about how you want
you master sheet to look.

Hope this helps.

Pete

 

[Michael]

On the cell you want your totals in the main screen type the = sign then sum
(; at this point click on the first value from the second sheet and then type
a comma and repeat until you have selected all sheets. Now just type a
closing parenthesis ")" no quotes, and you should get the total of all the
sheets in that master sheet.

 

[Ashish Mathur]

Hi,

Please read up on the Data > Consolidate feature

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com