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