Hi Mark

thanks for providing macro that is way above my head. I can just about for
the logic of formula, but VB!

Mark, the macro works, but it also drags down non-formula ie name of last
person on the list. comments etc. Is there a way round this? Also can I
assign a shortcut key?
If not, I will live with what you've given me

Thanks again

Sapper