How can I automate a 16 man wrestling bracket in Excell.
 

Hi out there in cyberspace,

I am trying to automate a workbook containing 14 sheets, each is a weight
class used for wrestling tournaments. I want to be able to enter results and
have the losing wrestler move down and or out in a consolation bracket. This
is my first attempt at using =if, and so far I have had little success. My
attempt, recorded in cell B6 looks something like this =if(B5="True" and_or_
B7="True", Copy_B5 and_or_B7 To B49)

B5=Wrestler 1
B7= Wrestler 2
Loser drops to Cell B49

Any help or guidance would be greatly appreciated,

Bob Imhof
Ridgway, Pennsylvania

you are not going to do it that way.
formulas return values, they cannot perform actions like
copy. i would use a helper column, assign each wrestler
and index then sort by the index. that would move the
wrestler up and down the list.

-----Original Message-----
Hi out there in cyberspace,

I am trying to automate a workbook containing 14 sheets,
each is a weight
class used for wrestling tournaments. I want to be able
to enter results and
have the losing wrestler move down and or out in a
consolation bracket. This
is my first attempt at using =if, and so far I have had
little success. My
attempt, recorded in cell B6 looks something like this =if
(B5="True" and_or_
B7="True", Copy_B5 and_or_B7 To B49)

B5=Wrestler 1
B7= Wrestler 2
Loser drops to Cell B49

Any help or guidance would be greatly appreciated,

Bob Imhof
Ridgway, Pennsylvania
.