Text cells, crosstabs? Drilling down?

[Jim]

I have a workbook with 100 identical format worksheets.
Each worksheet is an educational course. There are 25 row
labels down the left representing 25 different
competencies we need to teach. There are about 12 column
labels to indicate if the course helps teach the
competency and how it is measured if it is taught (such as
written exam, oral exam, lab practical, specific
competency on patient care, etc.) The cells only have
text data (many cells have no data whatsoever). Is there
any way to take advantage of something like a crosstab for
numerical data using excel? If excel cannot do this, is
there a way to import a 100 worksheet file into Access to
do something similar? Thanks for any suggestions.

Jim

 

[Dave Peterson]

The first thing I would do is to combine the data from all 100 separate
worksheets into one giant worksheet.

I'd include a column that tells me the type of info (course name??).

Then I'd look at Data|pivottable.

If you think that this might be worth trying, don't do all 100 worksheets.
Start small (3??) and see if it does what you want.

For what it's worth, I try to keep all may data in one worksheet. It makes
things like this lots easier.

And using Data|Filter|autofilter makes showing just the stuff I want pretty
easy, too.