View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default 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!