Forum Discussion
Excel
Some questions for you.
- Are you open to changing the way you do this?
- How experienced are you with Excel (my guess is "not too much")
- What is it that is "expiring"? Certification? Licensing?
You probably--not definitely, but probably--would be better served by a single, all-encompassing database, with the records of each staff member on that single database (single spreadsheet), rather than separate ones for each. Then there'd be a single summary sheet that could show what you want in the way of summary data, by letting Excel abstract it from the single, all encompassing database. That happens to be something at which Excel excels.
Is it possible for you to post an example of what your current workbook looks like, just without any real names or other identifiable data. In place of the real names, substitute characters from your favorite films or TV shows. Doing that--posting what you're working with--would help me or others make specific suggestions.
