Some of you may have seen my Previous, related thread thread . By request, that thread has been closed and I am opening a new one on a related, but infinitely more complex note.
The solution to the previous thread worked, but not well with my project. I'll go a little more in depth into how my project works, and try not to be too detailed and irritating.
I am trying to create a homebrew Learning Management System for some of the Training courses that my department offers. I've posted here a few times on the same project, and the advice from all previous posts has been excellent.
What I have so far allows users to input all of the relevant information about a participant, and then keep track of the dates when they took a particular course. They input this information with a Userform. This data goes into a Participant Master List, which is where the majority of the functions take place. There is a Workings sheet set to xlVeryHidden, which houses some other information, including results for searches, and finally there is the Report Template--the source of my original question.
The original question was how to make a formula that would track how many people from each department and site have attended training within a date range. That question was answered in the Previous, related thread thread. The new problem comes when a user tries to generate a report from this template. When a report is generated, the Template gets copied and pasted up to 5 times (in a yearly report, once for the total year, and once each for quarters 1-4), so I need a way to keep the date ranges dynamic to the iteration of the report.
What makes it potentially more complicated is that a user might want to generate two or three reports at the same time to compare side-by-side. I'm pretty sure I can make something that will do this, and allow it, but the way it's looking could be really complicated--extreme headache, and a lot of VBA coding.
So, my main question, I suppose is: Is there an easier way to do this?
I am more than happy to re-explain myself if I've confused anyone. I'm so close to this project (and half-crazy already), that it makes perfect sense to me all the time--other people, maybe not.
Any help is greatly appreciated.