Make lists of names of people who need training / Remove blanks from lists of names

[fjasper]

Hi everyone,

I have a spreadsheet table with a list of names down the left side, and a list of required training events across the top. At the intersection of the name and training event is a cell with the date the training was completed.

What I'd like to do with this is create a separate sheet that gives me a list, organized by training event, of the names of the people who have not completed that training.

For example, if this is my little spreadsheet:


_________security______marketing_______HR policy
Bill_______1/19/10_______1/5/10
Sally______1/1/10______________________2/13/10
Jim________4/1/10______________________2/1/10
Jane_______3/5/10_______ 2/21/10

What I'd like to have is this:

security_________marketing_________HR policy
_________________Sally______________Bill
_________________Jim________________Jane

or this:

marketing ________HR policy
Sally_____________Bill
Jim_______________Jane

so I can determine who needs to be at each training event. I have about 150 people and about 75 training events to track, so what I've been doing: filtering, copying and pasting, is labor intensive to say the least.

I have a mail merge document that lists training dates by individual, so each person can get a memo detailing which training they've done and which they need, but the department head wants a roll-up of requirements by event so the training can be scheduled, rosters generated, etc.

I think of myself as an intermediate user, but I'm not really literate with macros. I can type in a macro from detailed instructions, but I think in formulas rather than VBA.

Any help is appreciated.

Frank