Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 23rd 15, 09:48 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2015
Posts: 1
Default Need help creating individual employee lists from spreadsheet of training information

I keep a list of our employees and the safety training they have had. Employee names are in the first column, different training listed across the top (currently there are around 40) with dates under the training.

I am trying to create a separate report/list for each employee showing the training they have had and the expiration dates.

Name Audiogram Big Ben Dora Safety Orientation.......

How Often (years) 1 1 EXP
Arron, Abe
Barnes, Bob 30-Apr-15 31-July-15
Carnes, Cathy 28-Jul-14
Duffey, Dave 14-Aug 14

In the above example, the dates shown are when the training was taken. The 1 shows how long the training is good, so the expiration date can be calculated. Some training has a given expiration date, in that case I have entered "EXP" instead of the number of years the training is good for - and have entered the expiration date instead of the date the training was taken.

Any suggests are appreciated. Thank you.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreedsheet for Transfer of Undertakings Employee Information missystk Excel Discussion (Misc queries) 1 May 4th 10 05:07 PM
I am looking for a triathlon training spreadsheet or record berniefradd Excel Discussion (Misc queries) 0 December 3rd 06 07:21 AM
creating an advanced employee schedule henrikjt New Users to Excel 3 July 1st 06 08:13 PM
Keeping track of employee training IcarusFB Excel Discussion (Misc queries) 6 December 31st 05 03:14 PM
Help :Merge 2 employee information tables akhilash Excel Discussion (Misc queries) 1 November 29th 05 03:46 PM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017