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