| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a formula that pulls info. from many sheets within
I have a an excel file (Microsoft Excel 2003 version) that contains several
sheets. How do I create a new sheet with totals gathered from existing sheets within the same excel file. -- Carolina Girl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a formula that pulls info. from many sheets within
Assuming that the sheets are all of a standard format, the usual way is to
add a sheet at the start of them, say called 'First' and another at the end, before your summary sheet, called say 'Last', and then use =SUM(First:Last!A1) The First and Lasst sheets can be hidden to avoid confusion. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Carolina Girl" wrote in message ... I have a an excel file (Microsoft Excel 2003 version) that contains several sheets. How do I create a new sheet with totals gathered from existing sheets within the same excel file. -- Carolina Girl |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a formula that pulls info. from many sheets within
If the cells you want to sum are in different locations in each of the
worksheets you can use the following formula: Sheet1!A1+Sheet2!A110 If they values are in the same cell in each worksheet you can use the following: SUM(Sheet1:Sheet3!A1) Change the cell addresses as needed. -- Kevin Backmann "Carolina Girl" wrote: I have a an excel file (Microsoft Excel 2003 version) that contains several sheets. How do I create a new sheet with totals gathered from existing sheets within the same excel file. -- Carolina Girl |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a formula that pulls info. from many sheets wi
Help was greatly appreciated - your answer worked perfectly!
-- Carolina Girl "Kevin B" wrote: If the cells you want to sum are in different locations in each of the worksheets you can use the following formula: Sheet1!A1+Sheet2!A110 If they values are in the same cell in each worksheet you can use the following: SUM(Sheet1:Sheet3!A1) Change the cell addresses as needed. -- Kevin Backmann "Carolina Girl" wrote: I have a an excel file (Microsoft Excel 2003 version) that contains several sheets. How do I create a new sheet with totals gathered from existing sheets within the same excel file. -- Carolina Girl |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a formula that pulls info. from many sheets within
With formulas such as =SUM(Sheet1:Sheet2!A5)
You were not too specific so we do not know how the data is set out. Try Help with the search term: consolidate Try Google with search term: Excel consolidate sheets One of the hits is http://support.microsoft.com/kb/214270 Then come back when you can be more specific so we can help you better best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Carolina Girl" wrote in message ... I have a an excel file (Microsoft Excel 2003 version) that contains several sheets. How do I create a new sheet with totals gathered from existing sheets within the same excel file. -- Carolina Girl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create a formula in excel with using 2 columns of info? | Excel Worksheet Functions | |||
| How do I create a macro that pulls stock prices from a website? | Excel Discussion (Misc queries) | |||
| input # on sheet 1, pulls all info for # from sheet 2 | Setting up and Configuration of Excel | |||
| Type in Part number which pulls info from another wksheet | Excel Worksheet Functions | |||
| Can 1 create a excel dahboard charts that pulls from other Excels | Charts and Charting in Excel | |||
Hybrid Mode
