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.

[@sankarsandash1318]

Good programming. Lot of learning

[@rakshithabharadwaj6935]

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.

[@meledward2325]

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

[@ExcelDestination]

Excellent!

[@MohAboAbdo]

Thank You So Mutch, Sir.

[@sureshsomaiya3820]

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

[@ExcelDestination]

You are welcome!

[@samihakhenaka3845]

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 ??

[@1112GT]

Concept and application are explained very well. Thanks

[@ExcelDestination]

You are welcome😊

[@kumarsandy2008]

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?

[@sindarl01]

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

[@ashishmohan4707]

Hi very useful video and very practical need everyone for every project ......very 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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[@joypain4708]

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.

[@manojrajwade5656]

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

[@wirechair]

thank youfor this Sir!

[@ExcelDestination]

welcom

[@maxchung2419]

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

[@bluewhiteconstructions5400]

Awesome

[@nadermounir8228]

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 ?

[@ExcelDestination]

Good question! cutcopy mode = false is to avoid showing lining (when we manually copy, we can see this). You can try to delete cutcopy=false and activated code and see......what happens. Please share your experience also.

[@boogachap9022]

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

[@ExcelDestination]

I have uploaded a tutorial for cut and paste. you can watch that at following link :
ruclips.net/video/uQSDNhtcqSI/видео.html

[@boogachap9022]

@@ExcelDestination Thank you very much. I will check this out.

[@jusephwinclic165]

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

[@s.revathy9885]

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

[@user-tl5lw7rc3m]

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

[@ExcelDestination]

yes, it is possible. let me create a tutorial for this.

[@user-tl5lw7rc3m]

@@ExcelDestination Thank you very much

[@mavalswadh]

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

[@wongpeggy4363]

Dear sirs. But what if I have multiple worksheet?

[@srimana7778]

Please tell me how to sort data after adding to destination

[@vamanshenoy938]

I want to copy only two column values. In that case what should be the vba code

[@user-rh5bf4mi4q]

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

[@nunuji501]

Hi
I want to convert each column's excel data to separate text file.
Can you please help to do this.

[@ExcelDestination]

please send email at [e-mail] for any excel vba requirement

[@mavalswadh]

My code requirement is same but just i want to apply search in one column itself

[@sridevikumari5435]

Hi Sir, I ve a doubt in extracting data from Chrome browser... Could you pls help me on that.. I ve opened chrome thru shellexecute bcoz that is the only option I ve to open in chrome.. After that how to assign that window as object to extract data

[@ExcelDestination]

I am not sure

[@sridevikumari5435]

@@ExcelDestination ok thank you

[@rose78692]

Please explain about
If we want from date to date
Data to be show on another sheet

[@ExcelDestination]

ok. let me create another tutorial for that

[@svlogappachansvlog1449]

How can i do this fully automatically ?? Its mean when i added a new data in master sheet , how can it show second sheet without any action. Is possible??

[@ExcelDestination]

You can use this code at event programming at SelectionChange event.

[@svlogappachansvlog1449]

@@ExcelDestination thank you so much , i was waiting for your reply

[@gwyndylzhykhyzje.sumalde2865]

hello. im having trouble of VBA for my excel. how may I contact you for this concern if you agree to help me. thank you

[@ExcelDestination]

We are a freelancing team. We can work on any Excel VBA Development project. You can send your requirement at [e-mail]

[@pranavptulshyan4374]

Please also share the files used in the Video...!!!

[@clementlo8542]

Hi there , how do i set a colored cell if the conditions are met ?

[@ExcelDestination]

Please check following tutorial for that :
ruclips.net/video/F29G18GdTAQ/видео.html

[@clementlo8542]

@@ExcelDestination thank you for sharing that youtube video , it really help with my understanding of VBA coding. I just have one last query, i have used your code "If Worksheets("Source Data").Cells(i, 2).Value < Date Or Worksheets("Source Data").Cells(i, 3).Value < Date Then " with an OR statement to loop different columns . I am trying to highlight the cells which meet the given conditions. I tried using this code "Cells(i, 2).Font.Color = vbRed after the code, but I think it only applies to one condition. Do you have any suggestion how I can loop through the columns of cells and highlight the cells when it meets the given condition?
Yoiur help is much appreciated

[@rrrraaaacccc80]

👍

[@ExcelDestination]

thanks

[@xavierfernandes9683]

Hi I want to copy paste certain data from txt file to excel plz help

[@ExcelDestination]

for any excel vba project, you can write to [e-mail]

[@TheTraveler2222]

why is it "i" in "I=2 to 20"? Does "i" = row?