Hooo man, finally something works!!!. Thank you very much!

Thanks for the tip

Thank you for the information, four month searching how to do this and finally done. thanks!

Well explained and easily understood. Thanks

You save me a LOT of time THANKS!!!

you guys are going on well

Thx!

I did it, thank you so much

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?

Excellent can also include to send email on this selected data.

@centurychallenger

3 жыл бұрын

excellent idea, sir Kiran Kumar

@kirannikil

3 жыл бұрын

@@centurychallenger I am trying am not able to get. If you get this please tell me.

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.

Amazing

Thank you Sir -

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!

Hello, maybe you can help me, I want to use the "Indirect" function, how do I do that, can you give an example?

Hi, is it possible to copy and paste it with another workbook? instead of worksheet? thank you

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?

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

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

How to copy past specific value filtered data to another sheets

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

4 жыл бұрын

Me too. I want to add another range or column what code should i use?

@ludovicab8804

4 жыл бұрын

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

@centurychallenger

4 жыл бұрын

hi there, this may answer your question 2. kzread.info/dash/bejne/pWyup7SPktC7iKw.html

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

@centurychallenger

4 жыл бұрын

Perhaps removing your previous data once you copied it?

@gokulrajrajan5052

2 жыл бұрын

@@centurychallenger How can we do it by keeping the original data as it is ?

sir provide the code please

@centurychallenger

3 жыл бұрын

you can download the code here ^_^ 1drv.ms/x/s!AkMLI0B-DHbthcFzYJdCS4M8hp1CIw?e=WdgZlW Jesus love you

Nice tutorial sir, now how to copy selected conditions to a new workbook?

@centurychallenger

4 жыл бұрын

hi nuki sutomo, this may help ... kzread.info/dash/bejne/c3mhtdh9f7SaYdo.html

If I select report button on exel sheet multiple times same data is copied multiple times. How to get rid of it

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

@vivekr4690

4 жыл бұрын

Use clearcontents method to clear all the contents in the sheet where results are to be saved

how to fix paste destination in one file sheet1?

can i we sample file sir

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

@centurychallenger

4 жыл бұрын

Please engage my professional service, a paid service. Thank you.

@jevan2196

4 жыл бұрын

@@centurychallenger how

@centurychallenger

4 жыл бұрын

@@jevan2196 please write an email to me at cylau.kent (a) gmail dot com, attach your excel file too. Thank you

👍⭐️⭐️⭐️

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

what to change in this code when need to copy the row at a specific time like at 11:00:00 am

@centurychallenger

3 жыл бұрын

Use Microsoft Power Automate to schedule this task.

Hi! Is it possible to get the value = "A" OR "B" AND value = "X"? Thank you

@centurychallenger

4 жыл бұрын

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.

@christopherroxas23

4 жыл бұрын

@@centurychallenger Thank you Sir Kent!

@centurychallenger

4 жыл бұрын

I am glad can help,@@christopherroxas23

This does not work when you're searching for numbers.

help me code plesae! thanks

1.25 - 1.5x speed ftw