Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use Workbook tabs in a Worksheet
I have an Excel 2003 workbook with worksheet tabs named after the months of
the year (Jan, Feb, Mar, Apr,...) for 2009 and 2008. Each worksheet contains information about the activities for that month (Sales, attendance, new students, etc...). I wanted to create a Summary worksheet that summarizes each activity by year (2009 Sales, attendance, new students, etc...). I want to automatically update the Summary worksheet as new tabs are added without copying and pasting the new tabs (like 2010 information). Anyone have any ideas how I can do this? Summary: 2010 Jan Feb Mar 2009 Jan Feb Mar 2008 Jan Feb Mar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use Workbook tabs in a Worksheet
Some key "ifs"
If each monthly sheet (and any new sheet) follow the same structure and... If Sheet names follow a regular pattern then: You can use the INDIRECT function to help make life a little easier. Going with what appears to be your format, something like: =INDIRECT("'"&$A2&" "&$A$1"'!B1) This would create a reference to: 'Jan 2010'!B1 copying the formula down would change to: 'Feb 2010'!B1 See the XL help file for further info on using INDIRECT. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Texins Karate" wrote: I have an Excel 2003 workbook with worksheet tabs named after the months of the year (Jan, Feb, Mar, Apr,...) for 2009 and 2008. Each worksheet contains information about the activities for that month (Sales, attendance, new students, etc...). I wanted to create a Summary worksheet that summarizes each activity by year (2009 Sales, attendance, new students, etc...). I want to automatically update the Summary worksheet as new tabs are added without copying and pasting the new tabs (like 2010 information). Anyone have any ideas how I can do this? Summary: 2010 Jan Feb Mar 2009 Jan Feb Mar 2008 Jan Feb Mar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula needs to include several worksheet tabs in one workbook | Excel Discussion (Misc queries) | |||
My worksheet tabs can not be seen in my workbook. | Excel Discussion (Misc queries) | |||
How do I move the worksheet tabs to the top of the workbook? | Excel Discussion (Misc queries) | |||
Worksheet Tabs at bottom of Workbook | Excel Discussion (Misc queries) | |||
move the worksheet tabs in a workbook to left | Excel Discussion (Misc queries) |