E
Elton Law
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
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