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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
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 ??
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.
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?
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 ?
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.
@@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
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
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??
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
Concept and application are explained very well. Thanks
You are welcome😊
Thanks very much I am learning vba. This type of code very helpful Onceagain.. Thanks
You are welcome!
Good programming. Lot of learning
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.
Thanks, I was able to adapt this to meet my needs.
Excellent!
I need vba code for multiple columns met the status yes and move the row in different sheets
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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
You can use the “ if (condition a and condition b) and condition c then
Thank you! Very informative. How would you cut and paste - in the case that you are cleaning up data?
I have uploaded a tutorial for cut and paste. you can watch that at following link :
ruclips.net/video/uQSDNhtcqSI/видео.html
@@ExcelDestination Thank you very much. I will check this out.
Thank you very much ... is it possible to convert the range into a table and how can it be handled?
yes, it is possible. let me create a tutorial for this.
@@ExcelDestination Thank you very much
Hi , what condition to use if we have to keep few cells blank in upper rows , say (cell C2)
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 ??
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.
Please tell me how to sort data after adding to destination
Hello , code is good but i want to give if else condition meet than it should copy in worksheet 3
thank youfor this Sir!
welcom
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?
what is vba code for copy paste and cut paste based on cell value from master sheet to another respective sheets.
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 ?
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.
okay that's amazing but if some change happen on the first sheet edite data its not updated the other sheet or deleted
Dear sirs. But what if I have multiple worksheet?
I want to copy only two column values. In that case what should be the vba code
Hi there , how do i set a colored cell if the conditions are met ?
Please check following tutorial for that :
ruclips.net/video/F29G18GdTAQ/видео.html
@@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
My code requirement is same but just i want to apply search in one column itself
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
why is it "i" in "I=2 to 20"? Does "i" = row?
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
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??
You can use this code at event programming at SelectionChange event.
@@ExcelDestination thank you so much , i was waiting for your reply
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
We are a freelancing team. We can work on any Excel VBA Development project. You can send your requirement at Exceldestination@gmail.com
Hi
I want to convert each column's excel data to separate text file.
Can you please help to do this.
please send email at exceldestination@gmail.com for any excel vba requirement
Please explain about
If we want from date to date
Data to be show on another sheet
ok. let me create another tutorial for that
Thank You So Mutch, Sir.
Hi I want to copy paste certain data from txt file to excel plz help
for any excel vba project, you can write to exceldestination@gmail.com
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
I am not sure
@@ExcelDestination ok thank you
Why isn’t this working for me. I’m pulling incorrect data 🤔
Awesome
Please also share the files used in the Video...!!!
👍
thanks