ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Monthly tracking log (https://www.excelbanter.com/excel-discussion-misc-queries/201560-monthly-tracking-log.html)

Mudbug

Monthly tracking log
 
I am a €śmedium€ť skilled user. I need to track several different training
courses for about 200 people. I currently have about 6 headings, entering
the renewal training date due.
Example:

Name Course A Course B Course C
Mickey 3/09 10/10 9/09
Joe D. 4/10 5/09 11/08

I could sort by date, but then I would be constantly sorting by course name.
Is there a way to set this up so I can see each course with the closest date
identified in some way? Such as by color, or some sort of reminder/tickler?
Should I consider an Access program instead?

Thanx in advance!


JMay

Monthly tracking log
 
Look into using a Pivot Table

"Mudbug" wrote:

I am a €śmedium€ť skilled user. I need to track several different training
courses for about 200 people. I currently have about 6 headings, entering
the renewal training date due.
Example:

Name Course A Course B Course C
Mickey 3/09 10/10 9/09
Joe D. 4/10 5/09 11/08

I could sort by date, but then I would be constantly sorting by course name.
Is there a way to set this up so I can see each course with the closest date
identified in some way? Such as by color, or some sort of reminder/tickler?
Should I consider an Access program instead?

Thanx in advance!



All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com