I am creating a staffing request spreadsheet for my managers to use.

In the first worksheet Column A contains a list of employee names. When the managers dbl click the names of the employees they are recalling for work (or laying off), the cell will turn green.

From there, I would like to look up the corresponding address associated with the names in the cells that have been turned green. (names and address are located on second worksheet in same workbook)

I want to copy both the name and address onto a third worksheet. (from that third sheet, I am going to generate mail-merge form letters in Word). But I only want the third sheet to contain the names/addresses of the cells that are colored green on the first sheet.

Thanks for your help.
Kolette