Want to copy cells into new worksheet automatically by changing cell value to specifi

I'm preparing Forecast for sales persons, I have an overall worksheet per every sales sector to state their opportunities. and there is a column for probability, I need to do the follwoing scenario: if the probability set to be 100% (Win) I need to copy it into another worksheet for Won opportunities and if it set to be 0%, I need to copy it to another worksheet of lost opportunities. is that applicable and by which code. also if it is possible to delete those rows of Win/Loss opprotunities from the overall sheet

Thx in advance
Abeer

Assuming that you have sheets: Sheet1, Won, Lost
Assuming all values to look at are in column A

Please Login or Register  to view this content.

Probably the quickest way would be to automate AutoFilter

Please Login or Register  to view this content.