analysis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 28 Oct 2006 17:25 GMT

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 to this Message

Ron Coderre - 28 Oct 2006 18:28 GMT

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

> Hello
>
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message