Excel VBA Code to Copy Paste if Multiple Conditions are Met

Macros For Excel can reduce working time in excel effectively.
This VBA Macros example explains how to copy paste rows when
multiple conditions met.
You can learn excel vba multiple if statements step by step.

[rakshithabharadwaj]

Sir, this is very helpful. You have used I=2 to 20. Please explain how to loop untill last available data in the sheet to check the condition.

[GT]

Concept and application are explained very well. Thanks

[sureshsomaiya]

Thanks very much I am learning vba. This type of code very helpful Onceagain.. Thanks

[meledward]

Thanks, I was able to adapt this to meet my needs.

[ashishmohan]

Hi very useful video and very practical need everyone for every project big thanks to share with us.



If it can possible can you plzz provide us excel data file which you used.

Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[maxchung]

You can use the “ if (condition a and condition b) and condition c then

[joypain]

Thanks but I have a question. I have made the exact code and the data as in your vid. And everything works fine. But as soon as I copy my own data in one of the columns (and of course change it in the code for the right search text), it doesn't work anymore! Can you please tell me why? I found out that by TYPING the data instead of copying it, it does work (to much data to type). Why? Thank you and awesome vid.

[samihakhenaka]

Thanks for this tutorial very helpful. but I have a question : in my case i want to copy and past cells applying conditions in both columns and cells ==> this means that i don't want have a fixed colnames ( colnames will depend on a specific row values) how can i do this please ??

[nadermounir]

This is helpful. Thank you very much. Quick question: what is the purpose of wiring application.cutcopy mode = false. What is this for? Also the following code to activate the destination sheet? Isn't already activated when the data was pasted ?

[imtiyazibrahim]

sir, I have sheet : Cell A1 contain date and B1 contain Value, In sheet2 : CellA1 to A30 contain date, I need copy/move/paste the Value B1(from sheet1) to its respective date in sheet2 Please advice

[boogachap]

Thank you! Very informative. How would you cut and paste - in the case that you are cleaning up data?

[kumarsandy]

Hello, This is helpful but what if we need to put a filter on to that fields and as per the different items given in the column 2 of source data, would be copied separately as per the different items on different sheets as per the items name of the sheet. Could you please help onto that?

[manojrajwade]

Hi, what condition to use if we have to keep few cells blank in upper rows, say (cell C2)

[tllwrcm]

Thank you very much ... is it possible to convert the range into a table and how can it be handled?

[rhbfmiq]

what is vba code for copy paste and cut paste based on cell value from master sheet to another respective sheets.

[s.revathy]

I need vba code for multiple columns met the status yes and move the row in different sheets

[sindarl]

Hi.. thanks for the video..
can you pls explain, if i only need to copy data in column A and B, with multiple condition from column C and D? Thanks

[jusephwinclic]

okay that's amazing but if some change happen on the first sheet edite data its not updated the other sheet or deleted

[keithmcgee]

Why isn’t this working for me. I’m pulling incorrect data 🤔

[mavalswadh]

Hello, code is good but i want to give if else condition meet than it should copy in worksheet 3