Tying Several Worksheets Together in One Worksheet
 

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!

Tying Several Worksheets Together in One Worksheet
 

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

On Nov 3, 6:08*pm, strawberryangel83
wrote:
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!

Tying Several Worksheets Together in One Worksheet
 

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.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"strawberryangel83" wrote:

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!

Tying Several Worksheets Together in One Worksheet
 

Hi,

Please read up on the Data Consolidate feature

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"strawberryangel83" wrote in
message ...
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!