Using dropdown to copy rows of data from other sheets

[nihmrodd]

Hi All,

I have a workbook that has several sheets of skills unique to their particular job categories, with employees in those categories listed and rated on their skills (a skills or competency matrix, basically). On the final sheet, I need to be able to create an individual skill report. I've created two drop-down menus that allow a user to select first the job category, then an individual employee from that category.

What I want is that when the individual employee name is selected, two rows from that sheet will be copied to the current (individual report) sheet: the top row (listing the skills for that job category), and that individual employee's row (showing his/her scores on the skills). What I've got is two nice drop-down menus that do nothing.

I've tried using Data Validation and an =INDIRECT to get these rows copied, but that hasn't worked. Any suggestions?

Not particularly VB literate, so I'd prefer if possible to stick to straight Excel formulas/solutions if possible. Attached is a sanitized copy of the workbook. On the Individual Skills Report sheet I've manually copied the two rows I would want to see automatically copied for a sample employee as an example.

Many thanks,

Ryan

[nihmrodd]

Instead of trying to copy the entire two rows, formatting and all, would it be simpler if I put a standard formatting (text orientation, cell fill, etc.) in the destination rows and then had only the data copied over from the other sheet? Seems like it should be easier, but I still can't figure out how.