I am a vba rookie and have hit a wall.
Here is the general layout i'm trying to accomplish. I've created a gradebook for a school. Each teacher will have one grade workbook that can contain up to 12 subjects. These subjects are hidden via code unless a class name is entered in a cell on a "menu" page. Each subject has a class grade summary page.
I'm trying to make macro that will do the following:
1) determine if a class name has been entered in a certain cell in the menu page
2) if one has been entered then copy the summary page for that subject into a new workbook (of course only copy values only not formulas)
3) macro needs to do this for each of the 12 cells in the "menu" and return all the needed summary pages to the same new workbook.
that file can then be used to report grades to school office.
Is this possible? the only thing i have gotten to work is to have each summary page copy to its own new workbook and it still has the formulas
i've searched the forum and cant find any code that will do this even after i edit them to fit my layout.
please help.