Glad it helped ! <g
Thanks for the feedback
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Matt_hull1979" wrote in message
...
Max,

You're a star! it worked like a dream! I had to adapt it a little as i
have
over 500 staff in 30 different teams, so now I have an excel spreadsheet
that
is over 23,800 Kb worth of formulas!

Thanks for your help.