Conditional copy between two worksheets - VBA

L

lvcourtney

New Member
Joined
Oct 3, 2012
Messages
10
Hi I have a list of quotes that I track for five sales reps. Each sales rep has their own worksheet.

Capture1.jpg



I would like to copy data from Columns A, C, and D of each row to the corresponding rep's worksheet, based on the value of Column B (Rep)


Capture2.jpg



So that all of CL's quotes go on CL tab, etc...for all 5 reps.

I realize this has been covered many times here, and I really tried to search previous posts before asking but I couldn't make sense of it. Thanks in advance and let me know if I can clarify anything.
 
Last edited:

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Sort by date Sort by votes
Maybe I shouldn't have put VBA in the title...obviously in over my head here and no clue what I'm talking about.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
Counter in For Each loop
Replies
2
Views
447
Possum17
P
P
  • Question Question
Copy method of worksheet class failed" with pivot table
Replies
4
Views
481
programsam
P
A
  • Question Question
VBA Copy/Paste New Data Only
Replies
0
Views
446
ah2024_2024
A
N
  • Question Question
Excel VBA copy data to a worksheet in list form
Replies
0
Views
132
NewbieExcel123
N
M
  • Solved
VBA to Insert Mismatched Row in separate worksheet
2 3
Replies
21
Views
807
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top