Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
analysis
Hello
I have 52 sheets in the same workbook. Sheet 51 is a summary sheet, sheets 1 - 50 are detail sheets. I would like sheet 52 to be an analysis sheet. In the top corner of sheet 52 I would like to be able to put a code reference on and below it, it then lists all of the sheets that contain that code and what value the codes has next to it. What is the easiest way of doing this? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
analysis
Joe
Based on your several posts, it seems that while the data is in 51 sheets, you really need it consolidated into 1 list. I'm wondering if the real problem is the data structure. Is it absolutely necessary to have over 50 identical tables distributed over as many sheets? I'm guessing that each sheet pertains to a different category (week, dept., etc). If that's true, wouldn't it make more sense to have ALL of the data in 1 sheet, with a column that contains the category? For example, Col_A could contain Week01, Week02, etc. With all of the data in one data list, extracting, filtering, and reporting become much easier. If there is a perceived need to keep the current structure, can you share it? *********** Regards, Ron XL2002, WinXP "Joe" wrote: Hello I have 52 sheets in the same workbook. Sheet 51 is a summary sheet, sheets 1 - 50 are detail sheets. I would like sheet 52 to be an analysis sheet. In the top corner of sheet 52 I would like to be able to put a code reference on and below it, it then lists all of the sheets that contain that code and what value the codes has next to it. What is the easiest way of doing this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does the Data Analysis Toolbar Disappear | Excel Discussion (Misc queries) | |||
data analysis option not visible | Excel Worksheet Functions | |||
Recalculating a Regression Output in Data Analysis | Excel Worksheet Functions | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |