Hooo man, finally something works!!!. Thank you very much!
@borisvainrub6341
3 жыл бұрын
Thank you for the information, four month searching how to do this and finally done. thanks!
@hashanwch
3 жыл бұрын
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?
@jhynvalle496
4 жыл бұрын
Hi, is it possible to copy and paste it with another workbook? instead of worksheet? thank you
@Gudha_Ismintis
Жыл бұрын
Hi Kent - how do you do this BUT with different workbooks (Instead of Different Tabs)?
@doriaaa19
3 жыл бұрын
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!
@urquix96
4 жыл бұрын
You save me a LOT of time THANKS!!!
@usharaniyatish3879
2 жыл бұрын
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
@ludovicab8804
4 жыл бұрын
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. kzitem.info/news/bejne/1G6wq4aMm5-Gi34
@prinzessinmadonna
4 жыл бұрын
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?
@jusephwinclic165
3 жыл бұрын
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 !
@kirannikil
3 жыл бұрын
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.
@jssj16
4 жыл бұрын
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?
@owls1981
4 жыл бұрын
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.
@Joda-es5xd
4 жыл бұрын
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
3 жыл бұрын
@@centurychallenger How can we do it by keeping the original data as it is ?
@davecks3042
4 жыл бұрын
Well explained and easily understood. Thanks
@querrythis
5 ай бұрын
Thanks for the tip
@jonnavithulasandeepya8363
4 жыл бұрын
When I am following this code. only the first column is getting pasted. The code is not going through the sheet
@LongNguyen-kz2oe
Жыл бұрын
I did it, thank you so much
@qamruddinmohammedi7665
3 жыл бұрын
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.
@Noob-vl3dk
4 жыл бұрын
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.
@gerardvaneggermond9967
4 жыл бұрын
Hello, maybe you can help me, I want to use the "Indirect" function, how do I do that, can you give an example?
@ashrafhossain8911
3 жыл бұрын
If I select report button on exel sheet multiple times same data is copied multiple times. How to get rid of it
@moosa2363
3 жыл бұрын
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.
@binayyadav1987
2 жыл бұрын
Amazing
@christopherroxas23
4 жыл бұрын
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
@jevan2196
4 жыл бұрын
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
@michaelhillier8853
2 жыл бұрын
Thank you Sir -
@jordancopetkovski2646
4 жыл бұрын
When I click makes duplicate all times. how to stop that? Thanks
@ashimagupta9494
4 жыл бұрын
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
@viddongmalualruot7909
4 жыл бұрын
you guys are going on well
@joerivandenabeele6707
Жыл бұрын
Thx!
@dkpatel4470
4 жыл бұрын
How to copy past specific value filtered data to another sheets
@jayeshgaikwad7471
4 жыл бұрын
how to fix paste destination in one file sheet1?
@cristianfeliciano5758
4 жыл бұрын
This does not work when you're searching for numbers.
@saifurrahman1166
3 жыл бұрын
sir provide the code please
@centurychallenger
3 жыл бұрын
you can download the code here ^_^ 1drv.ms/x/s!AkMLI0B-DHbthcFzYJdCS4M8hp1CIw?e=WdgZlW Jesus love you
@SuperNukki
5 жыл бұрын
Nice tutorial sir, now how to copy selected conditions to a new workbook?
@centurychallenger
4 жыл бұрын
hi nuki sutomo, this may help ... kzitem.info/news/bejne/onujuap6iINlZKw
Пікірлер: 60