Formulas cannot copy anything, only return results to the cell in which they
reside.

Perhaps you could autofilter on the won or lost column and copy visible rows to
either won or lost sheet.

This could be automated using VBA.

See Ron de Bruin's site for code.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP

On Mon, 14 Jan 2008 14:36:04 -0800, Old_skills_lost
wrote:

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