Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tying 2 Excel spreadsheets together | Excel Discussion (Misc queries) | |||
tying columns of data into a specified page size | Excel Worksheet Functions | |||
tying columns of data into a specified page size | New Users to Excel | |||
Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
Tying an imported graphic to a cell | Excel Discussion (Misc queries) |