azlpeterson
New member
- Joined
- Feb 25, 2017
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi folks,
I'm not sure if something like this is possible, and if it is, I'm not even sure what to search for to figure out how to do it.
I work at a university where we have templates for each of our programs. So, for example. I work in the engineering department and therefore we have multiple disciplines, under multiple degrees. For example
Associates Degree: Civil, Surveying, GIS
Bachelor's Degree: Civil, Mechanical, Electrical, etc
Bachelor's Degree (Honours): Civil, Mechanical, etc.
Now, for EVERY discipline, we have an excel template to fill out for their chosen discipline and for the chosen level of education (Assoc, Bachelor, Bachelor (H)). It's rather time consuming going to each folder where the templates are saved, then re-save it to the student records folder, then fill it out, and so forth. We don't want to use the excel method of saving each individual file as a template at this time for our own reasons (so many files to deal with basically), but my idea that I am hoping is possible is this:
I want to create ONE file for each discipline (i.e.) CIVIL. Then I want to combine each template that belongs to that disciple (so again, Assoc, Bach, Bach (H)) into one workbook. On the first sheet, I would like to create a drop down menu that allows us to choose the degree type we want to work from and have it take us directly to that spread sheet.
Additionally, each template has 4 worksheets, the main one is the enrolment guide, the second one is an automatically created exemption guide that is based on formulas depending on what happens on the first sheet, the 3rd is the formula sheet for different course code drop down boxes that apply to the first sheet, and I can't remember what the fourth one is at the moment. I'm not sure if this is really relevant, or if all four sheets would just merge over into the 1 workbook for each template that is added (which is ideal). So, in total, each workbook would have roughly 20 sheets with in it.
I know this is a bit complicated for myself to explain, but hopefully someone 'gets it' and can give me some guidance on where to look/what to do. - Most appreciated!
I'm not sure if something like this is possible, and if it is, I'm not even sure what to search for to figure out how to do it.
I work at a university where we have templates for each of our programs. So, for example. I work in the engineering department and therefore we have multiple disciplines, under multiple degrees. For example
Associates Degree: Civil, Surveying, GIS
Bachelor's Degree: Civil, Mechanical, Electrical, etc
Bachelor's Degree (Honours): Civil, Mechanical, etc.
Now, for EVERY discipline, we have an excel template to fill out for their chosen discipline and for the chosen level of education (Assoc, Bachelor, Bachelor (H)). It's rather time consuming going to each folder where the templates are saved, then re-save it to the student records folder, then fill it out, and so forth. We don't want to use the excel method of saving each individual file as a template at this time for our own reasons (so many files to deal with basically), but my idea that I am hoping is possible is this:
I want to create ONE file for each discipline (i.e.) CIVIL. Then I want to combine each template that belongs to that disciple (so again, Assoc, Bach, Bach (H)) into one workbook. On the first sheet, I would like to create a drop down menu that allows us to choose the degree type we want to work from and have it take us directly to that spread sheet.
Additionally, each template has 4 worksheets, the main one is the enrolment guide, the second one is an automatically created exemption guide that is based on formulas depending on what happens on the first sheet, the 3rd is the formula sheet for different course code drop down boxes that apply to the first sheet, and I can't remember what the fourth one is at the moment. I'm not sure if this is really relevant, or if all four sheets would just merge over into the 1 workbook for each template that is added (which is ideal). So, in total, each workbook would have roughly 20 sheets with in it.
I know this is a bit complicated for myself to explain, but hopefully someone 'gets it' and can give me some guidance on where to look/what to do. - Most appreciated!