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