Thanks, but I don't think that the budget would stretch to a purchase of
Access. I also have to make it reasonably easy to use for the staffers.
--
Ray

"Andrea" wrote in message
...
Hi Ray,
maybe you should consider using a database like access. For the work you
have to do databases are much more powerfull than excel.

"Ray Rogers" wrote:

We have a group of about 90 people and my head wants me to put together a
list for retraining purposes. What I have come up with is this:

Name--------Training----------Part_Time-----Full_Time-----Etc
Joe Buck------PLC----------------No--------------Yes-----
Joe Buck------Welding-----------Yes--------------No-----
Joe Buck------CNC----------------No--------------Yes------
Jill Doe--------Software Skills----yes--------------No----
Jill Doe--------New Career--------Yes-------------Yes-------

I turn this into a list with the dropdown menus, so I can filter the
columns
using the headings.
On the whole it works quite well, but I was wondering if there is a more
elegant way where I don't have to enter everyone's name in several times,
depending on how many training courses we get to offer, and how many sign
up
for them. The number of columns could also change.

We're offering six courses right now, so that's a listing of 90 X 6= 540
names. I could use macro's for the repetitive data entry, but I was
wondering if anyone knew of another way I could set about this. We need
to
be able to filter for; how many people want to take a particular course,
and
what courses a particular person wants to take. As well as any other
criteria she (my head) wants to come up with.
--
Ray Rogers