I am trying to convert a database previously used in Access now they want it
in Excel. It is in an automotive production plant. Each production line has
15-25 stations. On each line an employee can be trained on one or more of
these stations. How would I put that into Excel?? I want to click on the
Employee and see what they are trained on, OR the reverse, click on the
workstation and see which employees are certified to work there. Any help
would be appreciated...

I did a similar Training Database for a Client. It's simply a database ( in
this case 15,000 rows), with each row listing all the details of a single
Training Instance, to include the Employee Name, DateTrained,
ProductionLineNumber, StationNumber, NameOfTrainer, LEVEL of training(ie IN
training, Trained, or cabable of being a Teacher), etc etc, and most
importantly, an "Expiration date", whereby the Employee must be re-evaluated
to see if his/her skills are still current for that Instance and maybe
re-tested. An individual Employee may have 1- 20 or more rows depending on
how many stations they are trained on. All the reporting can be easily done
with wth Autofilter, and if desired, automated by Macros......and formatted
into nicely presentable reports..........Each Production Line would have it's
own Matrix Report with Employees down the left side and Stations across the
top, and the intersections of the matrix dispaying a number indicating their
level of competance...............everything, including the database, the
ReportTempaltes, and all the macros to automate it are contained within the
one Excel file.......it really comes out as a pretty smooth
system...currently about 7meg in size.

hth
Vaya con Dios,
Chuck, CABGx3


"smack" wrote:

I am trying to convert a database previously used in Access now they want it
in Excel. It is in an automotive production plant. Each production line has
15-25 stations. On each line an employee can be trained on one or more of
these stations. How would I put that into Excel?? I want to click on the
Employee and see what they are trained on, OR the reverse, click on the
workstation and see which employees are certified to work there. Any help
would be appreciated...