Hi Skal,

I just received good advice with a problem I had (note the past tense ;o)

In your situation the use of VLOOKUP may be of some help and being immediate.

However, do keep in mind that people often change their e-mail addresses for any number of reasons, therefore, only use the newest one available. Same goes for their academic achievements or other pieces of info not shown on the sample workbook.

If the number of worksheets exceeds 3 or 4 it is probably better to go with the macro approach (much less typing :o)

Hope this doesn't throw a spanner into the works

Cheers

Elmar