Hi,

Basically if any of the names is selected in any of the drop down cells,
then the score that is next to that cell eg, 1a,2b, 3c, 4c is shown next to
the appropriate name in the APP sheets tab!

I have attached a copy of the worbook;
http://www.box.net/shared/hxr0isxpfi

I've tried all sorts but can't seem make it work!

Matt

This thread is also posted on
http://www.mrexcel.com/forum/showthr...=1#post2202650