Hi.

I used to work with Excel v3/v4 macros and now find myself needing to learn VBA quickly, to work on something already in use. My first task is to search for staff who have certain skills, to match those of another staff member, to provide cover in his/her absence.

The scenario is;

A workbook that has a worksheet for each month of the year.

Each workbook then has cells across the top for each day of the month

The first three columns comprise of name, employee number, skills

The employee number will always be one character (U) and sixalphas, including leading 0's

The skills will be a group of letters, sepearated by a comma (X, A, M, W, S) etc.

I will need to be able to input a employee number, a skill (or skills) and a date.

From this input I will need to return employees who match the skill (or skills) for the given date.

Please see the attached example, which has had sensitive data removed

Hope one of you experts can help, as I need to conjure something up by Friday.

Thanks and good luck

Dave