You mention you want to copy or move the activity sheet to another sheet
based on won/lost, but you are not specific so it will be difficult to tell
you exactly how to do what you want. Are you going to have a "Lost" sheet
and a "won" sheet? What do you want to move?

Les

"Old_skills_lost" wrote:


Here is what I need to do I have been working on a sales sheet that will
track the sales via a won loss ratio. Now what I have been trying to do is to
take all of the information from the "activity" sheet and copy or perfer move
it to a sheet based as "lost" or "Won". What I have worked out is the
following (r/c is short for row/colum)

=if(r/c="won", 'Won'! ,if(r/c="lost", 'Lost'! ,))

I think I have the start of this formula correct but as you can see i am
missing several key parts.