Hello,
I am using Excel 2003, I am attempting to set up a data base in excel as follows:
-I have a spread sheet that lists all the colleague I work with
-This spread sheet is updated bi-weekly with new hires
-I want to use excel to enter and track the completion of training sessions
-I need this database spread sheet to be used by 6 different people working in 6 different locations
-I want them to be able to enter in when training sessions have been completed for each of the colleagues on the spread sheet
-I would like to use a "user form" (VBA) to enter the completion of each training session
eg. Joe Blow has completed First-Aid training on Jan.15/2009, I want to have the ability to enter in Joe's colleague number which will then bring up his information from the spread sheet (date hired,position,other training completed) as well as have a spot to enter in the training he has just completed.
I have used Excel for a few years but very new to VBA, I have done allot of searching and it looks like this is possible.Problem is I don't know how to write the code that will make it work.
I am using Excel 2003, I am attempting to set up a data base in excel as follows:
-I have a spread sheet that lists all the colleague I work with
-This spread sheet is updated bi-weekly with new hires
-I want to use excel to enter and track the completion of training sessions
-I need this database spread sheet to be used by 6 different people working in 6 different locations
-I want them to be able to enter in when training sessions have been completed for each of the colleagues on the spread sheet
-I would like to use a "user form" (VBA) to enter the completion of each training session
eg. Joe Blow has completed First-Aid training on Jan.15/2009, I want to have the ability to enter in Joe's colleague number which will then bring up his information from the spread sheet (date hired,position,other training completed) as well as have a spot to enter in the training he has just completed.
I have used Excel for a few years but very new to VBA, I have done allot of searching and it looks like this is possible.Problem is I don't know how to write the code that will make it work.