If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
text cells, crosstabs? drilling down?
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 |
#2
|
|||
|
|||
text cells, crosstabs? drilling down?
See one response at your other post.
Jim wrote: 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 |
Thread Tools | |
Display Modes | |
|
|