Copy / Paste Different Columns from One Sheet to Another

Hi everyone,

I'm very new to VBA and am trying to learn. I have worked out a few things, but this is way over my head. I will post an example if it's necessary, but I think I can explain it well enough that it's not necessary.

I'd like to take a copy / paste the values from a few columns from the "Requirements" tab and paste them to the "Enrollment" tab if they meet a certain criteria. The columns from "Requirements" that I'd like copied are Col A, N, R, BD, and BE. I'd like them to be pasted in Col J, K, L, M, N (J:N) on the "Enrollment" tab, if anything in Col O of "Requirements" tab equals the value in "Enrollment!$D$5".

Please let me know if there needs to be further explanation. Hopefully, I could get away with not posting an example as there is a lot of client sensitive data on it and would take a while to remove. Thanks in advance!

With out looking at your data, it is difficult to test it, but try this code.
I am making few assumptions: You have a header on both sheets in row 1, so you are copying from row 2 to last row and also have headers on the destination tab

Please Login or Register  to view this content.

Thanks, @AB33, but I'm having some issues with that code. I finally got around to removing all the extra data and have attached the example inline. Let me know if you have any other questions / comments. Thanks!

Copy_Paste_Multiple_Col_Example.xlsx

ccowman,
Okay! I see what the issues are.
1. Your sheet name is not actually "Enrollment", but Enroll. This obvioulsy would give you an error.
2. On tab sheet "Enroll" Range D5 is not Team, but Test 4, and the names you have in column O is Team, so one of them must be wrong. Since you have team names in Column O, I suspect the range value in D might be Team 4, not Test 4
And lastly, you wish to copy the columns starting row 7,column J, Am I right? Please confirm this and code will be on its way

Sorry about that @AB33! I guess I should have just attached this from the beginning and prevented all the hassle / back and forth. LESSON LEARNED!

To answer your questions, I changed the tab from "Enrollment" to "Enroll" to save a few characters in typing. Sorry, D5 should say "Team 4" - that's a mistype by me. Yes, I would like to start the pasting in Row 7. I plan to have some header data at the top.

Thanks again for all the help!

Forget to format dates. Please see amended code post 6

Awesome! Works perfectly, @AB33! Thanks!