Can information be copied to a different

  • Thread starter Thread starter Old_skills_lost
  • Start date Start date
O

Old_skills_lost

I posted an earlier question that may have been in the wrong area.

Here is the question

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.
I know it can be cloned without using an answer such as the yes and no and
each cell at a time. I need the cloning to be done so that all information is
placed in another worksheet.

Thank you ahead of time for any help
 
I posted an earlier question that may have been in the wrong area.

Here is the question

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.
I know it can be cloned without using an answer such as the yes and no and
each cell at a time. I need the cloning to be done so that all information is
placed in another worksheet.

Thank you ahead of time for any help
Click to expand...

The easiest thing to do would be to Filter the original sheet on the
Won/Lost column for Lost, copy the Filtered contents, and paste to the
Lost sheet as Values. Repeat for the Won filter. You can capture the
key sequence using the Macro recorder to automate.

SteveM
 
Back
Top