Excel is a very versatile tool, as your article demonstrates.

A couple of mods I'd like to see in your code are:

1. Show the value from the other worksheet as a...

Many thanks for the response Jack.

I've used EAV tables before (although I didn't know that was what they were called!). I think they do the job when it comes to...

Thanks for the post Adriaan. It would be great if you could paste some sample code here!

Nick