Dear expert,
Would like to prepare the shift table.
Say I put 1 in cell A1
A2 to A13 will show up like this ...

Timmy
James
Patrick
Terence
Dion
Jasmine
Kammi
Steve
Ricky
Kelly
Fiona
Peggy

Say I put 2 in cell A1.

A2 to A13 will come up like this.

Terence
Dion
Jasmine
Timmy
James
Patrick
Kammi
Fiona
Peggy
Kelly
Steve
Ricky

It is hard to use "IF", becasue there are more than 7 choices ....
VB can definitely do, but I would like to have a try on worksheet function
first.

Thanks, Elton