I have an excel spreadsheet monitoring work done by staff at locations across England. Each row contains a project and is staffed by four people identified with column headings Lead, assist1 assit2 and cord. A staff can be a lead in one project and an assist in another. I need help with a VB code that will be able to pull out all projects undertaken by staff A whether they are the lead or assist1 and display the result information on a black spreadsheet within the work book called analysis. Thanks for you help all VB experts