Hi All,

I hope someone can help. Here is the situation: I have a worksheet which includes multiple tabs of summary reports (all identical format). Each tab has a list of names in column D and a set of check boxes linked to the adjacent cell in column C. Additionally, I have a "Detail Report" tab which allows the user to select from the list of names throughout the workbook, which will populate activity details about that particular person. What I want to do is allow the user to click on a check box next to a person in the name list from any one of the sheets and have a macro that will copy the adjacent name and paste to the reference cell on the detail report tab, uncheck the checkbox, and jump to the detail report. I am completely lost. (I posted an image below including shots of the basic sheet layouts I am dealing with)

I would greatly appreciate anyone's help. I am extremely strong when it comes to formulas and complex workbook functions, but when it comes to macros, I am a complete novice.

Regards,
Kate

Macro Actions.jpg