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]

See one response at your other post.

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