2 years before I saw your very valuable video. For nearly 10 days, I am searching this video. Thanking God to give me this link. Many Thanks to you for posting this valuable video.
Hi it was great , you made it simple & easy.... i would like to know how to move the updated data from the sheet 1 to sheet 2, i want to move only the the data added newly to sheet
Hi, this is very useful, thanks! How to copy cells adjacent to a keyword? Example: if keyword is found in cell A5, copy cells A2:A5 and cells B2:B5 to another worksheet.
first of all you need to find cell address through code and then selecting range and then copy and paste. I have another tutorial for copy and paste range at following link th-cam.com/video/fAis_cZ7cHs/w-d-xo.html
Code is very helpful, I was actually stuck in a similar situation and by looking at this tutorial, it made sense and i was able to make the needed changes on my end. Thank you!
Hi, very well explained. Could you please tell what needs to be done if we want to copy the row which met the condition and insert a new row below and paste it there?
Are you able to provide some advice if I have another criteria to be copied to another tab? Meaning I have criteria for sheet 2 and criteria for sheet 3?
Hello. Where can I find the codes you created in the videos? Do you have a repository where I pull the codes instead of creating from the videos? Appreciate your work..
How do you get it to copy to second page just adding to the bottom row and not copying it all over again? Is it an offset, or +1 row code??? Much needed help.
Thank you for the wonderful code! Works perfectly for my needs. Is it possible to add another if? So instead of the "North" search and paste, next can I search for "east"? I would really appreciate the help
This is such a great tutorial and exactly what I needed. How can I add onto this VBA to delete the row I just copied and pasted onto sheet 2 from sheet 1? And, how can I be sure I'm only pasting it 1 time (no duplicates)? Thank you!!
Is there a way to edit the code to avoid duplicating entries, in case you add new data to the main sheet and want to copy it to the other sheet without also recopying and pasting the old data that was already copied to the other sheet?
hi sir, super concept, i have doubt, if any possible to copy specific rows based on emp id eg: i want copy the data emp id like 1002, 1005, 1008 to another sheet (not based on region, salary) using textbox or any other method..kindly reply sir...
Brilliant! Thank you for this! So helpful. Is there a way to adjust the code so that I can add more rows to Sheet1, click on the Command Button and NOT have it recopy the previously entered rows? I hope that makes sense. I would like to be able to add more rows and only copy the new rows to the designated sheet. Or is there a function that will automatically filter the entire row to a new sheet based on the value of a certain cell in that row?
This is great - very helpful. I was able to kind of apply it to an issue I'm trying to resolve, but need the data to be pasted into a table on a different sheet. Is there an easy way to modify this code to do that?
How should the code be modified so that it only adds rows from Sheet1 to Sheet2 if they have not previously already been added? E.g. could it check to see if the Emp ID already exists on Sheet2 and if yes then to not copy that row again, but move on to the next one and check again before copying?
Hi,Thank you for this video. Is there a way I can copy only selected columns from that row and paste it in another excel? Let's say, my data is in row 2. So, when VBA matches the criteria in row 2, I wanted to only copy the details from Column A and B. Is it possible?
Great! Very well explained it. This is what I've been searching since more than a week.perfect! You're a lifesaver! Thank you very... much sir! God bless you!
hello there , this is a very useful video , but one small thing , if u added new data to the original sheet , and then press command button , it takes all data specified even the already copied ones before , is there any formula to copy only the new rows entered
If you push the button twice it just copies everything again. Is there a way to replace the data that's already been copied over to sheet2 or not copy data that's already been copied?
@Excel Destination I am having the issue of producing multiple copies onto my other sheets as well. Is there any way to stop this besides deleting the previous data each time? Also, how do I change the code to paste the data into rows in an excel table. This function pastes my data under my already created table. Thanks!
Thank you very much.... What do I do if I need to copy 4 best rows out of 20 with high value... To another sheet and it goes on updating daily... 🙏Thank you
Very good work, thanks so much. I need to know , How to add clear content function in the same code to clear all data in sheet 2 (except headers) before pasting. otherwise how to copy and past starting from sheet 2 Cell A2 each time. waiting for valluable replay. Thanks
Thanks! Great video - useful and easy to follow steps. Is it possible to transfer only certain columns when "North" criteria is met? Or would you recommend I have a working-tab, whereby the data is pasted into it and then another macro removes the columns, before repeating the first process, albeit from a different sheet. Thanks in advance.
Thanks for watching! You can take help from another tutorial for creating specific range to copy only specific columns for each row. Link is : th-cam.com/video/6edvmcCvCkA/w-d-xo.html
Always excellent. Do you have any advice on updating code when inserting adding and deleting columns? Is there a way to make the cell / range references dynamic in the code? Thank you
If we wants to do the same between two different workbooks rather than two worksheets in single workbook, can you please help. It would be a great help if you could help me here by providing code for this. Example: I have two workbook called workbook1 and workbook2. I want to copy rows if condition is met from workbook1 and paste it in workbook2. Thanks
Sir I m following your channel since long. I have learnt a lot. Thank U . I have one question .. i want to update data if condition met i.e. ID, If ID Exists data should be updated but if ID doesn't exist the data should be save in last row of database. Kindly help.
Its like very nice,but 1 Question. If I want to set criteria as Date(Today),means I want to transfer the data on daily basis using date criteria. What code should I use?
This worked as a charm, all though when I click the command button couple of times the same data keeps on copy pasting multiple times. It would be better if it could only refresh. Could you help me out on this solution?
that would require additional code to prevent duplicate. You can find tutorial "to prevent duplicate using vba" at this link : th-cam.com/video/yPUCx9HTVvo/w-d-xo.html
I copied the code and receive a "Run-time error "424': Object required" message when I run the the macro. The only difference I have is that I changed the fourth line of code to "If Worksheets("Sheet1").Cells(i, 5).Value = "Closed" Then" because the criteria I'm using is "Closed" and that is in the fifth column. I would appreciate your assistance with two questions; 1. Can the word "Copy" be changed to "Move" in he fifth line of code since I want to move the data, and 2. What code is needed if I want to move data based upon two criteria; "Closed" or "Completed"? Thank you very much.
I was able to make this work, but how can it get it to work if the names are different? Such as "NORTH" , "North" , "north". I can get it to copy but only if I put in every possible combination. Just seems a bit redundant. Any help would be great. Thanks
you can add additional code to convert all values in same case like in Upper Case or Proper Case. Then it will work for you. For help, you can check following example : th-cam.com/video/RD1VFRpBdZw/w-d-xo.html
Is it possible to string together multiple command buttons into one? Also to stop it from copy pasting if it is a duplicate? Multiple command buttons say if I want to copy past from a master list to assign to a sales reps sheet, but I have multiple sales rep sheets.
I need it to check if t copied the row before because I am using this sheet on a daily basis so I need to copy the new rows only and not duplicating the rows each time
Hi! Video is excellent and very helpful however, I have one doubt. I have multiple keywords and I have written multiple codes like the same code sheet. Now I want a line of code to be added in this code in such a way that after executing one code it should automatically add an entire row after the last filled row and then take next set of code and apply till last. I tried it many ways but I am not able to get it. Please help me out.
Great video, I have a sheet imported from another program where the columns change constantly depending on the data. I would like to look for a certain column header, and if it exists, copy that whole column to another sheet, can you think of a way to do this?
Thank you for your appreciation....I have already uploaded one tutorial for similar requirement....you can watch at th-cam.com/video/_2h2Buzhcf4/w-d-xo.html Please share your feedback and don't forget to subscribe...thanks again
Thanks for your great tutorial!Could you please tell me how to send the selected data using outlook automatically?I mean when click the send button then the selected data will be pasted in the email body.Thanks in advance!
Sir I want to know that if new data is added in sheet1 then whatever new data met condition that will be merge into another sheet ,,instead of the whole (including new data) data should be added into the sheet2...sir kindly tell me.
HI Thanks for your video. Instead of filtering can we paste by entering count value in one column. Ex: Sheet is having 1000 Rows of data A to E Column I don't want to paste all 1000 entries at a time. 1st time I want to paste only 50 buy clicking transfer button, Second time 50 like based on our selection. If this is possible can you please share code or if you have done already please share video link... Thanks.
Ok, I have an Excel VBA challenge for you. I need the VBA module statement that basically says "if the content from cell range B$-G$ matches from one of the previous sheet's B$-G$ content, but can/will be a different row, copy the previous sheet's H$ content and formatting to the current sheet's respective by content cell H$." Copying notes from one tab to another, week to week, but the row number positions can, and do, change. Some Row's contents falls off (deleted) week to week which makes the pasting location dynamic by Row based on cell contents in the same Row. Also the Sheet names are variable, but will always be looking to the previous sheet on the left.
Thanks Prabhu for your question :) I will create tutorial for transferring rows when multiple conditions met.........very shortly.........that will answer your question.
Thank you for making this complicated thing easy. We really appreciate you for your effort sir. Since you are an expert in vba, how can I paste the rows in the second column of the destination sheet ?
Thanks Dhananjay, you can send me email at EXCELDESTINATION@GMAIL.COM with your contact detail...I will respond with my contact detail...and then we can discuss further...thanks again...
Question: I have one column that the values include "Morning'", "Noon", or "Evening" shifts. I would like to copy the rows of those employees that are in the "Morning" or "Evening" Shifts from one sheet to another, if either or these conditions are met using the looping concept such as the one above video example you have. Thank you :)
Nice one, easy to understand , with afew extra lines i have macro that can search a list of numbers against a several thousand line spread sheet and extract the rows with those numbers in.
Awesome video and very well explained. I have one question for you... Instead of pasting in the next available row, how would I paste in the next available column? So.. if column D contains data, and I want my query to start pasting the copied data to column F, row 1 for instance.
Would it be:- b = Worksheets ("Sheet2").Cells(Columns.Count, 1) .End(x1Up).Column instead of b = Worksheets ("Sheet2").Cells(Rows.Count, 1) .End(x1Up).Row?
Maybe I can Explain this a little better. I have data listed in rows in "Sheet1": A B 1 king hearts 2 king clubs 3 king diamonds 4 queen hearts 5 queen clubs 6 queen diamonds 7 ace hearts 8 ace clubs 9 ace diamonds I want to use your method with three individual command buttons for each individual card suit (hearts, clubs, diamonds) to copy & paste them in "Sheet2" in the following way:- A B C D E F 1 king hearts king clubs king diamonds 2 queen hearts queen clubs queen diamonds 3 ace hearts ace clubs ace diamonds Can this be done? If so, how? I would be extremely grateful if you have an answer as I've been trying to get this to work for months, but I absolutely totally understand if you are too busy to get to it.
@@ExcelDestination the below is the code that i have... could you please add the additional code? Sub copycolumns() Dim lastrow As Long, erow As Long lastrow = Worksheets("2020").Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To lastrow If Worksheets("2020").Cells(i, 24) = "PENDING" Then Worksheets("2020").Cells(i, 3).Copy erow = Worksheets("Pending").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 1) Worksheets("2020").Cells(i, 4).Copy Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 2) Worksheets("2020").Cells(i, 6).Copy Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 3) Worksheets("2020").Cells(i, 24).Copy Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 4) Worksheets("2020").Cells(i, 26).Copy Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 5) End If Next i Application.CutCopyMode = False Worksheets("Pending").Columns.AutoFit Range("A1").Select End Sub
I am a beginner of VBA, and can understand almost all your explanation. Well done! Described.
Cool, thanks!
lol nnjjjkjnjjkkiuuu we j I'll LP ok thhbskkn we lu hnmjubnk j we usei
@@ExcelDestinationن❤٧٧خخخخمنمهههت٠عه٨ههنط😊٨ههندظمن١منهطهنخممههننكظشحح٣خضخقخشخشخششصج١٦٨٢خخص٨٢٧٣٨ط٥نخشيشهشخذ٨ه٨دنهخمممممح😎😄😉😉😁😀😁🖤😚
دمممخه٩٠٠ت❤٨نح
Awesome explanation brother, simple words full concept, easily understood...thanks so much for sharing
Finally, a competently explained video!
thanks
2 years before I saw your very valuable video. For nearly 10 days, I am searching this video. Thanking God to give me this link. Many Thanks to you for posting this valuable video.
😮😮😮😢😊ñññ . Mi
Well done! This was my first VBA program in Excel.
😊Zffggbggv
Zeeshan
ةةل الإمامين تشوفي.
غتبؤذ قمر البوم
YES, It works. Really good for new learners who wants to begin VBA Excel 👍👍👌👌
Thanks 😊
Thanks bro. Your vid is very useful for beginner like me!
THIS IS WHAT IWANT!! AMAZING 🥰🥰🥰
Thanks
It was surprisingly difficult to find anything else with this information here. This was very helpful to me for my little project at home. Thanks!
Hey man! Exactly my thoughts haha
Right this can't be such a rare task....
@@Philip-dy3ww .1
@@jlpayne052710 😊9😅o😊 poop ooh 😮 9😊😅o😊 of l😅😅😅
@@Philip-dy3wwu
Short and concise- plain English
Keep up the good work.
Exactly what i was looking for sir. Thank you so much.
You are most welcome
@@ExcelDestination Sir i there any way to find top 10 largest value in a column and copy the corresponding row value to another sheet???
, 3$64* & -'&_60$c, yd3
Hello Sir, Very nicely explained about the VBA Code & very easy to grab it, pls keep up the good work, we learn from you a lot.
Thanks a lot for your great words!
Excel Destination I was trying to add your formulas in my task but am getting an error, don't know how to proceed, pls advise.
I need your help in filling an Excel spreadsheet, where am trying to put your formula & it comes as Run time error, pls advise.
Thank you my man for simplifying this, you explained it a manner that totally makes it easy to understand. Bravo!
22صصصصص3ڪ
@@نبأنعمةكركانهنن ٨٠ج٠❤🎉دَ٠٠
ر و.
This is a fabulous code, I have been using offset to go to the next available row, this vba code is much better.... thanks.
thanks for your great comment!
Hi it was great , you made it simple & easy....
i would like to know how to move the updated data from the sheet 1 to sheet 2,
i want to move only the the data added newly to sheet
Hey the explanation is good, wanted to know, what would be the code if i need to copy a row based on duplicate values in a particular column.
Thank you sir. It is very useful
I used this for cut and paste.
But sheet1 has blank cells. How can I remove that blank cell automatically.
Hi, this is very useful, thanks! How to copy cells adjacent to a keyword? Example: if keyword is found in cell A5, copy cells A2:A5 and cells B2:B5 to another worksheet.
first of all you need to find cell address through code and then selecting range and then copy and paste. I have another tutorial for copy and paste range at following link
th-cam.com/video/fAis_cZ7cHs/w-d-xo.html
Code is very helpful, I was actually stuck in a similar situation and by looking at this tutorial, it made sense and i was able to make the needed changes on my end. Thank you!
Thanks for watching and your comment!
Excellent code. Works great! Thank you.
Thanks for the comment!
Hi, very well explained. Could you please tell what needs to be done if we want to copy the row which met the condition and insert a new row below and paste it there?
You can take help from following tutorial :
th-cam.com/video/_8pl0oRbt-U/w-d-xo.html
Thank you very much, it was exactly what i needed!
Are you able to provide some advice if I have another criteria to be copied to another tab? Meaning I have criteria for sheet 2 and criteria for sheet 3?
for any excel vba support, you can write to exceldestination@gmail.com
Very informative. Thanks for this.
Glad it was helpful!
Very well explained sir thank you
Welcome
Thanks this was very useful, I adapted it for copying only matching columns to destination sheet
Hi do u mind sharing how u did that? Thx.
Hello. Where can I find the codes you created in the videos? Do you have a repository where I pull the codes instead of creating from the videos? Appreciate your work..
I am working on repository. Till then, you can follow the tutorial and pause it also to note down the complete code.
How do you get it to copy to second page just adding to the bottom row and not copying it all over again? Is it an offset, or +1 row code??? Much needed help.
Kinda late but did you ever find a solution to this?
Very helpful and transposable to other tasks, thank you.
You're very welcome!
You are so great. Appreciate this very much. Sail on.
Thank you kindly!
Thank you for the wonderful code! Works perfectly for my needs. Is it possible to add another if? So instead of the "North" search and paste, next can I search for "east"? I would really appreciate the help
Please follow the instructions, given in the below tutorial :
th-cam.com/video/bm3M-9NwS1k/w-d-xo.html
@@ExcelDestination Thanks so much - found that before and forgot to tell you :)
This is such a great tutorial and exactly what I needed. How can I add onto this VBA to delete the row I just copied and pasted onto sheet 2 from sheet 1? And, how can I be sure I'm only pasting it 1 time (no duplicates)? Thank you!!
Thank you very much for the tutorial. It really helped with the task I had at university.
Can I give two column conditions?
If I have two columns stating North, for example you gave.
1.000.0000.0000.0000 Thanks to You!! You solve my problem ;)
I need VBA code same, but pasting in sheet2 from 10th. row. Can you please reply with required modification row only to insert with this code?
you can start you looping statement from 10th row.......in that case.
Is there a way to edit the code to avoid duplicating entries, in case you add new data to the main sheet and want to copy it to the other sheet without also recopying and pasting the old data that was already copied to the other sheet?
there is a specific tutorial for VBA Code to prevent duplicate entries. Please watch that at following link :
th-cam.com/video/yPUCx9HTVvo/w-d-xo.html
hi sir, super concept, i have doubt, if any possible to copy specific rows based on emp id eg: i want copy the data emp id like 1002, 1005, 1008 to another sheet (not based on region, salary) using textbox or any other method..kindly reply sir...
Brilliant! Thank you for this! So helpful. Is there a way to adjust the code so that I can add more rows to Sheet1, click on the Command Button and NOT have it recopy the previously entered rows? I hope that makes sense. I would like to be able to add more rows and only copy the new rows to the designated sheet. Or is there a function that will automatically filter the entire row to a new sheet based on the value of a certain cell in that row?
Hi, were you able to find solution to this?
Excel Destination, please give the solution to this.
This is great - very helpful. I was able to kind of apply it to an issue I'm trying to resolve, but need the data to be pasted into a table on a different sheet. Is there an easy way to modify this code to do that?
you can always modify the code
very nicely done bro. What if I want only some cells to be pasted if a condition is met? Any video on that ?
you can take help from following tutorial :
th-cam.com/video/6edvmcCvCkA/w-d-xo.html
Perfect! Excellent video Sir. Keep up the good work. It solved my problem. Thanks
Great to hear!
Awesome Video! I wonder if something like this can be done in MS Word.
Great video. Thank you very much. I plan to use this at work next week to save tons of time.
How should the code be modified so that it only adds rows from Sheet1 to Sheet2 if they have not previously already been added? E.g. could it check to see if the Emp ID already exists on Sheet2 and if yes then to not copy that row again, but move on to the next one and check again before copying?
Hi,Thank you for this video. Is there a way I can copy only selected columns from that row and paste it in another excel?
Let's say, my data is in row 2. So, when VBA matches the criteria in row 2, I wanted to only copy the details from Column A and B. Is it possible?
you can take help from following tutorial for creating range from row and column :
th-cam.com/video/6edvmcCvCkA/w-d-xo.html
Did you know how to make it works ?
@@Ramzyar didn't try yet.
@@rashmiranjan86 Worksheets("Sheet1").Range("A" & i & ",B" & i).Copy
Great! Very well explained it. This is what I've been searching since more than a week.perfect! You're a lifesaver! Thank you very... much sir! God bless you!
You're welcome!
You're awesome! Thank you for this.
Welcome
Everything explained perfectly, appreciate that man.
hello there ,
this is a very useful video ,
but one small thing , if u added new data to the original sheet , and then press command button , it takes all data specified even the already copied ones before ,
is there any formula to copy only the new rows entered
you can add some more vba code to prevent duplicate. check this :
th-cam.com/video/yPUCx9HTVvo/w-d-xo.html
If you push the button twice it just copies everything again. Is there a way to replace the data that's already been copied over to sheet2 or not copy data that's already been copied?
Did you ever find a solution to this?
Hi, thanks for the sharing and love it!.
However, I want to paste only values, how do we amend the code "ActiveSheet.Paste"?
THANKS SIR FORM THAT WONDERFUL PROGRAM BUT I NEED TOU HANDLE LARGE AMOUNY OF DATA BY THAT WAY IS THIRE ANY EXCEL TEMPLE I CAN USE TO FOLLOW STEPS ?
@Excel Destination I am having the issue of producing multiple copies onto my other sheets as well. Is there any way to stop this besides deleting the previous data each time? Also, how do I change the code to paste the data into rows in an excel table. This function pastes my data under my already created table. Thanks!
Hi Larry, Thanks for your question. For any excel vba work, you can write to exceldestination@gmail.com
Thank you so much!!! I've been trying to do this all day. Your tutorial worked perfectly!
😮 😮 good zginkkkkkkkkkkkkkjjjjjjjjjjjjjmmmmmmmkkkkmmmkkkkkkkkkkkkkkkkkkkjkjjkkkkkkkkkhjjjjjjjjhhhhhhhhhhhhjhhhbjbbhhhhb
wonderful explanation! thank you so much for sharing your knowledge!
Thanks Jennie!
Many thanks! So helpful!! What would be the code if i wanted to duplicate (copy twice) the value into sheet2? thanks in advance for the answer!
You can do that using nested loop.
Thank you very much.... What do I do if I need to copy 4 best rows out of 20 with high value... To another sheet and it goes on updating daily... 🙏Thank you
let me create a tutorial soon to identify top 3, top 4 etc. by checking values in a range. Thanks for your question.
Very good work, thanks so much. I need to know , How to add clear content function in the same code to clear all data in sheet 2 (except headers) before pasting. otherwise how to copy and past starting from sheet 2 Cell A2 each time. waiting for valluable replay.
Thanks
I can give you logic. first check the last filled row and then run loop from last row to 2nd row and then delete all rows.
THIS is Awesome! Do you happen to know if it will find specific texts (Key words) with the cell?
Thanks! Great video - useful and easy to follow steps. Is it possible to transfer only certain columns when "North" criteria is met? Or would you recommend I have a working-tab, whereby the data is pasted into it and then another macro removes the columns, before repeating the first process, albeit from a different sheet. Thanks in advance.
Thanks for watching! You can take help from another tutorial for creating specific range to copy only specific columns for each row. Link is :
th-cam.com/video/6edvmcCvCkA/w-d-xo.html
Ii0
2🦄☺️🙂
Always excellent. Do you have any advice on updating code when inserting adding and deleting columns? Is there a way to make the cell / range references dynamic in the code? Thank you
ILllo
If we wants to do the same between two different workbooks rather than two worksheets in single workbook, can you please help.
It would be a great help if you could help me here by providing code for this.
Example: I have two workbook called workbook1 and workbook2.
I want to copy rows if condition is met from workbook1 and paste it in workbook2.
Thanks
Sir I m following your channel since long. I have learnt a lot. Thank U . I have one question .. i want to update data if condition met i.e. ID, If ID Exists data should be updated but if ID doesn't exist the data should be save in last row of database. Kindly help.
Fantastic, very easy description !!! Thank You
Its like very nice,but 1 Question. If I want to set criteria as Date(Today),means I want to transfer the data on daily basis using date criteria. What code should I use?
let me create tutorial for that.
we can change the line If Worksheets("sheet1").Cells(i, 3).Value = Worksheets("sheet1").Cells(3, 7).Value Then and put condition in cells(3,7)
This worked as a charm, all though when I click the command button couple of times the same data keeps on copy pasting multiple times. It would be better if it could only refresh. Could you help me out on this solution?
that would require additional code to prevent duplicate. You can find tutorial "to prevent duplicate using vba" at this link :
th-cam.com/video/yPUCx9HTVvo/w-d-xo.html
I copied the code and receive a "Run-time error "424': Object required" message when I run the the macro. The only difference I have is that I changed the fourth line of code to "If Worksheets("Sheet1").Cells(i, 5).Value = "Closed" Then" because the criteria I'm using is "Closed" and that is in the fifth column. I would appreciate your assistance with two questions; 1. Can the word "Copy" be changed to "Move" in he fifth line of code since I want to move the data, and 2. What code is needed if I want to move data based upon two criteria; "Closed" or "Completed"? Thank you very much.
sure, if you can send me your file at exceldestination@gmail.com , I can correct your code.
I was able to make this work, but how can it get it to work if the names are different? Such as "NORTH" , "North" , "north".
I can get it to copy but only if I put in every possible combination. Just seems a bit redundant.
Any help would be great.
Thanks
you can add additional code to convert all values in same case like in Upper Case or Proper Case. Then it will work for you. For help, you can check following example :
th-cam.com/video/RD1VFRpBdZw/w-d-xo.html
Is it possible to string together multiple command buttons into one? Also to stop it from copy pasting if it is a duplicate? Multiple command buttons say if I want to copy past from a master list to assign to a sales reps sheet, but I have multiple sales rep sheets.
I need it to check if t copied the row before because I am using this sheet on a daily basis so I need to copy the new rows only and not duplicating the rows each time
you can check tutorial for preventing duplicates at following link :
th-cam.com/video/yPUCx9HTVvo/w-d-xo.html
Thanks for the Video.
I have one doubt. How i can do the same in Google sheet?
Hello. It did work for me. But how could I change the code in order to update the sheet if I introduced new data in my first sheet?
By watching ur video i think acha din aa raha hai sir ji 😇😇😇😇
I really appreciate your comment!
Searched hard for an explanation of how to achieve this. Brilliantly explained. Well-paced. The spreadsheet gods smile upon you !
Thanks Mike for your superb comment! I really appreciate this kind of encouragement!
Hi! Video is excellent and very helpful however, I have one doubt. I have multiple keywords and I have written multiple codes like the same code sheet. Now I want a line of code to be added in this code in such a way that after executing one code it should automatically add an entire row after the last filled row and then take next set of code and apply till last. I tried it many ways but I am not able to get it.
Please help me out.
La me
What if I wanna copy more rows based on other matching text below the above condition
please check following tutorial :
th-cam.com/video/bm3M-9NwS1k/w-d-xo.html
To be precise I wanna group all north...foloowed by South..so on
Great video, I have a sheet imported from another program where the columns change constantly depending on the data. I would like to look for a certain column header, and if it exists, copy that whole column to another sheet, can you think of a way to do this?
Thank you for your appreciation....I have already uploaded one tutorial for similar requirement....you can watch at th-cam.com/video/_2h2Buzhcf4/w-d-xo.html
Please share your feedback and don't forget to subscribe...thanks again
Thanks for your great tutorial!Could you please tell me how to send the selected data using outlook automatically?I mean when click the send button then the selected data will be pasted in the email body.Thanks in advance!
let me create turorial for that
@@ExcelDestination okay
Perfect ,thank you so much. How can I do CUT and PASTE with same way
instead of copy, you need to use code of cut
Thanks for easy way learning
Welcome
Sir I want to know that if new data is added in sheet1 then whatever new data met condition that will be merge into another sheet ,,instead of the whole (including new data) data should be added into the sheet2...sir kindly tell me.
HI Thanks for your video. Instead of filtering can we paste by entering count value in one column.
Ex: Sheet is having 1000 Rows of data A to E Column I don't want to paste all 1000 entries at a time. 1st time I want to paste only 50 buy clicking transfer button, Second time 50 like based on our selection. If this is possible can you please share code or if you have done already please share video link... Thanks.
Ok, I have an Excel VBA challenge for you. I need the VBA module statement that basically says "if the content from cell range B$-G$ matches from one of the previous sheet's B$-G$ content, but can/will be a different row, copy the previous sheet's H$ content and formatting to the current sheet's respective by content cell H$." Copying notes from one tab to another, week to week, but the row number positions can, and do, change. Some Row's contents falls off (deleted) week to week which makes the pasting location dynamic by Row based on cell contents in the same Row. Also the Sheet names are variable, but will always be looking to the previous sheet on the left.
Heading didn't appear and also if we have to few more regions to be select say like north and south as well what changed to be made in VB ? Please
Thanks Prabhu for your question :) I will create tutorial for transferring rows when multiple conditions met.........very shortly.........that will answer your question.
Thank you for making this complicated thing easy. We really appreciate you for your effort sir. Since you are an expert in vba, how can I paste the rows in the second column of the destination sheet ?
how to paste the range in rows eg:D1:J1, i am getting it pasted in columns eg D1:D10
awesome bro...sir I will take ur help if u allow bcz ur concept is crystal clear .... awesome
Thanks Dhananjay, you can send me email at EXCELDESTINATION@GMAIL.COM with your contact detail...I will respond with my contact detail...and then we can discuss further...thanks again...
Question: I have one column that the values include "Morning'", "Noon", or "Evening" shifts. I would like to copy the rows of those employees that are in the "Morning" or "Evening" Shifts from one sheet to another, if either or these conditions are met using the looping concept such as the one above video example you have. Thank you :)
A
Nice one, easy to understand , with afew extra lines i have macro that can search a list of numbers against a several thousand line spread sheet and extract the rows with those numbers in.
Glad it helped!
Great video. What if I want to move the rows, not just copy?
there would be small change in this code. You can take help from another tutorial at th-cam.com/video/UJSQpqBNswk/w-d-xo.html
great work ...thank you so much , it makes data visibility so easy
Thank you for watching!
Awesome video and very well explained. I have one question for you... Instead of pasting in the next available row, how would I paste in the next available column? So.. if column D contains data, and I want my query to start pasting the copied data to column F, row 1 for instance.
you can use same logic to count the last filled column.
@@ExcelDestination Any chance you could elaborate? I am not a programmer by any means, so I don't really know how to code it.
Would it be:- b = Worksheets ("Sheet2").Cells(Columns.Count, 1) .End(x1Up).Column instead of b = Worksheets ("Sheet2").Cells(Rows.Count, 1) .End(x1Up).Row?
Maybe I can Explain this a little better. I have data listed in rows in "Sheet1":
A B
1 king hearts
2 king clubs
3 king diamonds
4 queen hearts
5 queen clubs
6 queen diamonds
7 ace hearts
8 ace clubs
9 ace diamonds
I want to use your method with three individual command buttons for each individual card suit (hearts, clubs, diamonds) to copy & paste them in "Sheet2" in the following way:-
A B C D E F
1 king hearts king clubs king diamonds
2 queen hearts queen clubs queen diamonds
3 ace hearts ace clubs ace diamonds
Can this be done? If so, how? I would be extremely grateful if you have an answer as I've been trying to get this to work for months, but I absolutely totally understand if you are too busy to get to it.
help me to write same code for 2 conditions
say i want to copy 2 values(north and south) not 1 in different sheet
Please check another tutorial for multiple conditions at below link :
th-cam.com/video/bm3M-9NwS1k/w-d-xo.html
Very nice tutorial..shore and simple..detailed..keep it up Sir..
😢😢😂😂😂😮😮😅😊😊
how to use partial search function instead of Value in 4th line:= If Worksheets("sheet1").Cells(i,3)Value="north" then
Thanks. oks fine. how about if data is in different work book. copy and paste only condection met
Is there a way to do this in a script to use in Excel online?
What if we would want the button to clear sheet2 first and then copy the data each time?
yes, that can be done with some additional vba code.
@@ExcelDestination where can i find that additional code?
@@ExcelDestination the below is the code that i have... could you please add the additional code?
Sub copycolumns()
Dim lastrow As Long, erow As Long
lastrow = Worksheets("2020").Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To lastrow
If Worksheets("2020").Cells(i, 24) = "PENDING" Then
Worksheets("2020").Cells(i, 3).Copy
erow = Worksheets("Pending").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 1)
Worksheets("2020").Cells(i, 4).Copy
Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 2)
Worksheets("2020").Cells(i, 6).Copy
Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 3)
Worksheets("2020").Cells(i, 24).Copy
Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 4)
Worksheets("2020").Cells(i, 26).Copy
Worksheets("2020").Paste Destination:=Worksheets("Pending").Cells(erow, 5)
End If
Next i
Application.CutCopyMode = False
Worksheets("Pending").Columns.AutoFit
Range("A1").Select
End Sub