| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for multiple tabs in one worksheet
=SUM(Sheet2:Sheet100!A1)
Entered in a cell on Summary leadsheet. If your sheetnames are unique then the best course is to insert a new sheet just right of Summary and insert a new sheet after last sheet. Name these First and Last =SUM(First:Last!A1) When adding more sheets insert them anywhere between Fiest and Last Gord Dibben MS Excel MVP On Wed, 17 Feb 2010 14:51:02 -0800, Excel makes life easier <Excel makes life easier @discussions.microsoft.com wrote: I have a standard template for all tabs in one workbook (there are about 100 different tabs). What is the function to sum the same cells in each tab and carry over to a summary leadsheet? Would this be similar to running a report? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple rows of Worksheet Tabs at bottom | Excel Discussion (Misc queries) | |||
| How do I view multiple tabs on the worksheet | Excel Worksheet Functions | |||
| Multiple Worksheet Tabs - Search Option? | Excel Worksheet Functions | |||
| link multiple tabs in new worksheet | Excel Discussion (Misc queries) | |||
| Worksheet tabs on multiple lines? | Excel Worksheet Functions | |||
Threaded Mode
