Hello. I have an urgent question. 1. Why when selecting the column to copy you use "" for A, ":" for B and "," for E and not "" for all? 2. I have a ComboBox. I would like that my criteria is the selected value of the Combolist. I can do it with the same program? Thanks :)
@@jevan2196 i found the way. follow the simbols that you see in the video and I mention. If you want to add column D for example use ",D" as you dif for the third one. Don't ask me why, but it works
amazing thank you alot but still need more when this data edtied like change a to b updated it's not work can you please tell us how we will solve that !
Thank you for the information. What if I want to move Categories A and B from the "data" sheet to the "report" sheet and then delete those rows from the "data" sheet? How is that done? Thank you.
Hi Kent, Thank you so much for this video! Really easy to follow! Quick question, what if I want to paste the data into a new workbook and not on a different sheet within the same workbook?
Hi Amazing Ken, Hi, I created a VBA that will copy and paste entire rows if the if statements are met and copied to a specific tab. I created the command button to assign the macros. The data gets copied to the new tabs as designed. However, each time I click on the button it duplicates the data in the desire tabs. How can I create or add to my VBA not to duplicate the same data? Thanks
What if its for continues use? For example I have a new entry. Then I want it to copy on the other sheet but dont copy the old entries? I tried it but the old entries also copied. Please help
Hi Sir. How can I do, if I want to see paste result starting at the Row 3 or Row 4 on Report Sheet.You Know What I means? Now Your paste Result is show starting at the Row 2. Please help me Sir.I will waiting your reply Sir.
hi Christopher Roxas, it is possible... change to this - If (Worksheets("data").Range("C" & r).Value = "A" Or Worksheets("data").Range("C" & r).Value = "B") And _ Worksheets("data").Range("D" & r).Value = "X" Then but if you have PowerQuery, this job can easily done with it, no longer need VBA coding.
Dear Sir, Want transfer data from one workbook to another. Workbook - A 1. Receipt No. 2. Date 3. Name 4. Amount To Workbook - B in two different Sheets can you please help to write correct VBA code.
Hi, I prepare the same code in My Excel to copy paste data, it is working fine but whenever I run this code it shows duplicate data. Can we overwrite it on old data whenever we run the code
Hooo man, finally something works!!!. Thank you very much!
Thank you for the information, four month searching how to do this and finally done. thanks!
You save me a LOT of time THANKS!!!
Excellent can also include to send email on this selected data.
excellent idea, sir Kiran Kumar
@@centurychallenger
I am trying am not able to get. If you get this please tell me.
Thanks for the tip
I did it, thank you so much
Hi, is it possible to copy and paste it with another workbook? instead of worksheet? thank you
Amazing
sir i have an request resolve this query , i m using input box to get the details only specifc date format .. it i enter any format else
Hi Kent Good morning. Thanks for your valuable video. But When I try to run 1st code, its open MACRO window. Can you help me?
Hi Kent - how do you do this BUT with different workbooks (Instead of Different Tabs)?
Well explained and easily understood. Thanks
When I am following this code. only the first column is getting pasted. The code is not going through the sheet
Hii. When I test this, only the last row in the range which meets the condition is being copied to the new sheet. Do you know why?
Thank you Sir -
Hello. I have an urgent question.
1. Why when selecting the column to copy you use "" for A, ":" for B and "," for E and not "" for all?
2. I have a ComboBox. I would like that my criteria is the selected value of the Combolist. I can do it with the same program? Thanks :)
Me too. I want to add another range or column what code should i use?
@@jevan2196 i found the way. follow the simbols that you see in the video and I mention. If you want to add column D for example use ",D" as you dif for the third one. Don't ask me why, but it works
hi there, this may answer your question 2. th-cam.com/video/s8zERVbmUXI/w-d-xo.html
what to change in this code when need to copy the row at a specific time like at 11:00:00 am
Use Microsoft Power Automate to schedule this task.
amazing thank you alot but still need more when this data edtied like change a to b updated it's not work
can you please tell us how we will solve that !
Hi Kent, Thank you for the amazing tutorial, my VBA coding is working fine but the button is not working. Could you please advise? Thank you!
Thx!
If I select report button on exel sheet multiple times same data is copied multiple times. How to get rid of it
Thank you for the information. What if I want to move Categories A and B from the "data" sheet to the "report" sheet and then delete those rows from the "data" sheet? How is that done? Thank you.
Hi Kent, Thank you so much for this video! Really easy to follow! Quick question, what if I want to paste the data into a new workbook and not on a different sheet within the same workbook?
Hi Amazing Ken, Hi, I created a VBA that will copy and paste entire rows if the if statements are met and copied to a specific tab. I created the command button to assign the macros. The data gets copied to the new tabs as designed. However, each time I click on the button it duplicates the data in the desire tabs. How can I create or add to my VBA not to duplicate the same data? Thanks
Perhaps removing your previous data once you copied it?
@@centurychallenger How can we do it by keeping the original data as it is ?
how to fix paste destination in one file sheet1?
Hello, maybe you can help me, I want to use the "Indirect" function, how do I do that, can you give an example?
you guys are going on well
What if its for continues use? For example I have a new entry. Then I want it to copy on the other sheet but dont copy the old entries? I tried it but the old entries also copied. Please help
Please engage my professional service, a paid service. Thank you.
@@centurychallenger how
@@jevan2196 please write an email to me at cylau.kent (a) gmail dot com, attach your excel file too. Thank you
sir provide the code please
you can download the code here ^_^ 1drv.ms/x/s!AkMLI0B-DHbthcFzYJdCS4M8hp1CIw?e=WdgZlW Jesus love you
How to copy past specific value filtered data to another sheets
Hi Sir. How can I do, if I want to see paste result starting at the Row 3 or Row 4 on Report Sheet.You Know What I means? Now Your paste Result is show starting at the Row 2. Please help me Sir.I will waiting your reply Sir.
Hi! Is it possible to get the value = "A" OR "B" AND value = "X"? Thank you
hi Christopher Roxas, it is possible... change to this - If (Worksheets("data").Range("C" & r).Value = "A" Or Worksheets("data").Range("C" & r).Value = "B") And _
Worksheets("data").Range("D" & r).Value = "X" Then
but if you have PowerQuery, this job can easily done with it, no longer need VBA coding.
@@centurychallenger Thank you Sir Kent!
I am glad can help,@@christopherroxas23
When I click makes duplicate all times. how to stop that? Thanks
Dear Sir,
Want transfer data from one workbook to another.
Workbook - A
1. Receipt No.
2. Date
3. Name
4. Amount
To Workbook - B in two different Sheets
can you please help to write correct VBA code.
Hi, I prepare the same code in My Excel to copy paste data, it is working fine but whenever I run this code it shows duplicate data. Can we overwrite it on old data whenever we run the code
Use clearcontents method to clear all the contents in the sheet where results are to be saved
help me code plesae! thanks
This does not work when you're searching for numbers.
can i we sample file sir
👍⭐️⭐️⭐️
Nice tutorial sir, now how to copy selected conditions to a new workbook?
hi nuki sutomo, this may help ... th-cam.com/video/AEmSvDOQ41w/w-d-xo.html
1.25 - 1.5x speed ftw