Excel VBA Code to Copy Paste if Multiple Conditions are Met

Рет қаралды 57,032

4 жыл бұрын

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.

Пікірлер: 59

@samihakhenaka3845 3 жыл бұрын

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

@rakshithabharadwaj6935 3 жыл бұрын

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.

@kumarsandy2008 2 жыл бұрын

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?

@meledward2325 4 жыл бұрын

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

@ExcelDestination 4 жыл бұрын

Excellent!

@joypain4708 3 жыл бұрын

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.

@sureshsomaiya3820 4 жыл бұрын

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

@ExcelDestination 4 жыл бұрын

You are welcome!

@manojrajwade5656 3 жыл бұрын

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

@sankarsandash1318 2 жыл бұрын

Good programming. Lot of learning

@1112GT Жыл бұрын

Concept and application are explained very well. Thanks

@ExcelDestination Жыл бұрын

You are welcome😊

@sindarl01 2 жыл бұрын

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

@nadermounir8228 4 жыл бұрын

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 4 жыл бұрын

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.

@ashishmohan4707 4 жыл бұрын

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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

@MohAboAbdo 4 жыл бұрын

Thank You So Mutch, Sir.

@boogachap9022 3 жыл бұрын

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

@ExcelDestination 3 жыл бұрын

I have uploaded a tutorial for cut and paste. you can watch that at following link : kzfaq.info/get/bejne/q7eDd7GZ2cnVg30.html

@boogachap9022 3 жыл бұрын

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

@maxchung2419 4 жыл бұрын

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

@imtiyazibrahim4193 8 күн бұрын

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

@s.revathy9885 3 жыл бұрын

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

@wirechair 2 жыл бұрын

thank youfor this Sir!

@ExcelDestination 2 жыл бұрын

welcom

@jusephwinclic165 3 жыл бұрын

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

@user-tl5lw7rc3m 4 жыл бұрын

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

@ExcelDestination 4 жыл бұрын

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

@user-tl5lw7rc3m 4 жыл бұрын

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

@user-rh5bf4mi4q 8 ай бұрын

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

@wongpeggy4363 4 жыл бұрын

Dear sirs. But what if I have multiple worksheet?

@nunuji501 4 жыл бұрын

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

@ExcelDestination 4 жыл бұрын

please send email at exceldestination@gmail.com for any excel vba requirement

@srimana7778 3 жыл бұрын

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

@bluewhiteconstructions5400 3 жыл бұрын

Awesome

@sridevikumari5435 4 жыл бұрын

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 4 жыл бұрын

I am not sure

@sridevikumari5435 4 жыл бұрын

@@ExcelDestination ok thank you

@mavalswadh Жыл бұрын

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

@gwyndylzhykhyzje.sumalde2865 3 жыл бұрын

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 3 жыл бұрын

We are a freelancing team. We can work on any Excel VBA Development project. You can send your requirement at Exceldestination@gmail.com

@rose78692 3 жыл бұрын

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

@ExcelDestination 3 жыл бұрын

ok. let me create another tutorial for that

@svlogappachansvlog1449 3 жыл бұрын

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 3 жыл бұрын

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

@svlogappachansvlog1449 3 жыл бұрын

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

@TheTraveler2222 5 ай бұрын

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

@clementlo8542 3 жыл бұрын

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

@ExcelDestination 3 жыл бұрын

Please check following tutorial for that : kzfaq.info/get/bejne/fJhpepRprMq4cYU.html

@clementlo8542 3 жыл бұрын

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