Hi Guys.
I have a worksheet on which I keep my sales accounts.
It looks something like this:-
<tbody>
</tbody>
As you can see in Column G i have a status cell, the states are Active, Sold, Closed and On Hold.
What I would like to do is copy the row from the main sheet (named Leads) to a worksheet based on the status cell. Each status having their own worksheet.
I don't want the infomation removing from the Leads sheet just copying. I would like this to be done automatically as the status cell is changed to whatever it is currently. Also if the status changes from active to closed for instance I would like the infomation removing from the Active worksheet and put in the Closed worksheet.
I hope I have explained myself.
If not please feel free to berate me
Thanks in Advance
I have a worksheet on which I keep my sales accounts.
It looks something like this:-
A | B | C | D | E | F | G | H | I | J | K |
Name | Created | Project | Type | Date for Action | Current Action | Status | Status Changed | Value | Commission | Turnaround |
Smith | 4 April 2018 | ******* | Retail | 4 April 2018 | Call | Active |
<tbody>
</tbody>
As you can see in Column G i have a status cell, the states are Active, Sold, Closed and On Hold.
What I would like to do is copy the row from the main sheet (named Leads) to a worksheet based on the status cell. Each status having their own worksheet.
I don't want the infomation removing from the Leads sheet just copying. I would like this to be done automatically as the status cell is changed to whatever it is currently. Also if the status changes from active to closed for instance I would like the infomation removing from the Active worksheet and put in the Closed worksheet.
I hope I have explained myself.
If not please feel free to berate me
Thanks in Advance