I have a list of all players names in column B and then allocate each a
division number in column C ( next to each name ). I need a formula to copy
the correct name into their allocated division on another sheet automatically
when a number is entered in column C. ie each Division will have its own
sheet so instead of retyping all the names i need a formula to create each
division by just entering the number next to each players name.

Hope this is better understood

"Potter72" wrote:

I'm a novice to Excel and using formulas.
I'm doing a league format with 4 divisions.
I've got a list of players in column b and the chosen division in column c.
What formula can i use to automatically put the names into the respaective
divisions without have to copy / retype all the names each time.
DGET or an =IF rule ? I've tried loads but get nothing to transfer.

Help Please