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
.