Excel VBA to Copy and Paste Rows if multiple Conditions is Met
HTML-код
- Опубликовано: 17 июн 2019
- Watch the Part 2 video too
• VBA Copy and Paste R...
Watch the Part 3 video too
• Part 3 - Filter using ...
🙂 Attn: Accountant, Finance Analyst, Business Analyst, Training Manager
✔️ Do you want to help your staff to reduce there time to prepare Business Report, HR salary report, Cost Center Medical Fee Report, Profit & Loss report?
(from 2 hours to less than 2 min.)
✔️Do you look for an experienced online Excel coach?
hi, my name is Kent Lau, I offer online Excel course, e-book, downloadable videos, and online support (for member only).
👍 Malaysia government-approved PSMB Certified Trainer.
👍 15 Years track record.
👍 Microsoft Excel Macro/VBA Expert
I also do one-to-one online private coaching.
Please email me at cylau.kent@gmail.com, Thank you.❤️❤️❤️
Want to sponsor me to do a better video?
www.paypal.com/cgi-bin/webscr...
Join AmazingExcel school:
amazingexcel.teachable.com/
Thank you for the information, four month searching how to do this and finally done. thanks!
Hooo man, finally something works!!!. Thank you very much!
Well explained and easily understood. Thanks
You save me a LOT of time THANKS!!!
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?
you guys are going on well
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.
Thanks for the tip
Hello, maybe you can help me, I want to use the "Indirect" function, how do I do that, can you give an example?
I did it, thank you so much
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!
Thank you Sir -
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?
Amazing
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?
Hi, is it possible to copy and paste it with another workbook? instead of worksheet? thank you
Hi Kent - how do you do this BUT with different workbooks (Instead of Different Tabs)?
How to copy past specific value filtered data to another sheets
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.
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 ?
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. ruclips.net/video/s8zERVbmUXI/видео.html
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.
When I am following this code. only the first column is getting pasted. The code is not going through the sheet
Nice tutorial sir, now how to copy selected conditions to a new workbook?
hi nuki sutomo, this may help ... ruclips.net/video/AEmSvDOQ41w/видео.html
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
When I click makes duplicate all times. how to stop that? 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
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
If I select report button on exel sheet multiple times same data is copied multiple times. How to get rid of it
how to fix paste destination in one file sheet1?
can i we sample file sir
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.
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! 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
👍⭐️⭐️⭐️
help me code plesae! 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.
sir provide the code please
you can download the code here ^_^ 1drv.ms/x/s!AkMLI0B-DHbthcFzYJdCS4M8hp1CIw?e=WdgZlW Jesus love you
This does not work when you're searching for numbers.
1.25 - 1.5x speed ftw