And on my master sheet, if it possible that when i copy the cell name, it
change it to the proper team and week at the same time...

Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then
when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1
=T1WK3.......AN SO ON!


THX You!

Yan
Hi Yan Its Len from Adelaide Australia
your 2nd problem answer is to type out and highlight your list
Goto Tools, options, Custom Lists tab & Import you highlighted list
Click OK
Now you can use your list just like Jan, Feb, Mar etc
Hope this works out for you
Len - Adelaide Australia