jaymichaeljones
New Member
- Joined
- Mar 22, 2018
- Messages
- 4
Good Afternoon,
I'm new here and would appreciate any help that can be given. I've got a sheet that is attached here whereby I would like to move the whole row to another tab based on a set criteria.
Is there a generic VBA that i can plug my data into in order to make this happen? If you look at the below data set, I want to have anything labeled "REP 1" and "Won" moved over to a tab that is called "REP 1". I have 5 seperate reps, each with their own tab, that i'd be moving data to from the raw data set as displayed below:
Below is the data set I'm working from that the data would be copied FROM.
So the two criteria would be the REP #, and won. I'd like any sale won by each rep to be moved to that reps tab.
I hope this makes sense, and again I'd be truly thankful for any help that could be given here.
Best,
J
<tbody>
</tbody>
I'm new here and would appreciate any help that can be given. I've got a sheet that is attached here whereby I would like to move the whole row to another tab based on a set criteria.
Is there a generic VBA that i can plug my data into in order to make this happen? If you look at the below data set, I want to have anything labeled "REP 1" and "Won" moved over to a tab that is called "REP 1". I have 5 seperate reps, each with their own tab, that i'd be moving data to from the raw data set as displayed below:
Below is the data set I'm working from that the data would be copied FROM.
So the two criteria would be the REP #, and won. I'd like any sale won by each rep to be moved to that reps tab.
I hope this makes sense, and again I'd be truly thankful for any help that could be given here.
Best,
J
Lead Name | Size | Assigned To | Archived at | Pipeline | Archived By | Won/Lost | Cause | |
MIKE | 5 | REP 1 | 5:50 PM | 1st | DAVID | WON | PRICE | |
David | 8 | REP 3 | 6:00 PM | 2nd | Stacy | LOST | Negotiating With Someone else | |
<tbody>
</tbody>