It has been a long time since i have used Excel formula and have forgotten
how to write what I am needing.
What I need to do is that the answer from a colum that would be a yes or no
answer and copy the row to another worksheet based on the answer. For example
name: John doe sale: won address:112 blah street

Since this sale is won the row needs to be copied to the won sheet and if it
would have been a lost the row would have been copied to the lost sheet.

Thank you ahead of time for any help