[absthechatter]

Thanks for that. I have not used VLOOKUP or Macros much before and am a real novice. I will read through and give it a try.

Do you think it would be easier if I transferred the 100 spreadsheets to something like Access?

Thanks again for your help.

Abs