Hi

This is quite hard to explain. However, I will give it a go.

I export data from an Access Database into Excel that shows my teams
performance. There are approxmiately 8 different worksheets that are
exported into one file. However, I will name two they are

Jobs Sched
Jobs comp

In another worksheet I have setup a spreadsheet that utilises the countif
facility.

However this gets to be a pain when you have people come and leave the
company. Therefore, is there anyway that I can setup a spreadsheet that
looks up the names, places them in one column and then collates the data
into the relevant coloumns adjacent to them. Thus leaving me with people
that have actually done work and cutting my time down in programming the
countif facility.

Sounded better than I thought and someone tell me there is.

Regards