I have 2 spreadsheets set up, one called caseloads and one called pipeline.

Basically there is one sheet on the caseloads workbook for each person.

What i want E7 to do is count how many times that persons name appears on the pipeline workbook in column A.

Anyone have any ideas how to do this?

To make it easier the pipeline workbook is currently called Book1


I hope this all makes sense