Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to avoid making a list
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making a list | Excel Discussion (Misc queries) | |||
making a list ?¿ | Excel Worksheet Functions | |||
Making a list | Setting up and Configuration of Excel | |||
Making a new list | Excel Discussion (Misc queries) | |||
making a non-validation list | Excel Worksheet Functions |