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
Can we do like this. for suppose if we have data set range of a:e. For a:c we have text & d:e we have numbers. If we encounter duplicates in a:c. can we add those values in duplicate rows to the primary unique row? So ultimately totals in d:e will same
Good day could your code be adjusted to cater for an excel table and delete duplicate rows based on cell values in one of the columns in the excel table. Example Range of excel table is A:BY and if the cells values in BY = 2 delete the duplicate row. Your assistance would be greatly appreciated.
Sir I have a question! how to add the quantity of the same duplicate and just one unique will display! For example duplicate value of "1003","aaa", total qty: 4+7=11. And the expected output would like this. Is this possible sir?
Hi sir/mam This is Siva Kumar, I used to follow ur videos tutorials. In VBA to delete duplicate rows scenario I have a doubt. This code is working when last row matches with last before row then it keeps remain one row and delete other row. It's not working when there is existence of last row in second r third row from top. This code executes from bottom. Am I correct? Please assist me how to resolve this. Thanks in advance.
Hi Siva...thanks for watching my tutorials...actually...I have tested this code at my end...and then uploaded this tutorial...there is a logic for running loop from bottom to top...and before loop...we need to sort data...so logic wise...first sorting of data...then count total lines...then running loop from bottom to top...in case you need any of my help in vba...please write to EXCELDESTINATION@GMAIL.COM....THANK AGAIN...and keep watching :)
Hi Sir, My duplicate value is in column H, I changed the column but still duplicate are getting removed from Column A. Plz reply what mistake I am doing.
you can try different buttons on different tab. Because if you use both buttons on one tab, some different code will be required for activating sheet etc.
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
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
Can we do like this. for suppose if we have data set range of a:e. For a:c we have text & d:e we have numbers. If we encounter duplicates in a:c. can we add those values in duplicate rows to the primary unique row? So ultimately totals in d:e will same
Good day could your code be adjusted to cater for an excel table and delete duplicate rows based on cell values in one of the columns in the excel table. Example
Range of excel table is A:BY and if the cells values in BY = 2 delete the duplicate row.
Your assistance would be greatly appreciated.
Hello Sir, How are writing the codes?. I would like to learn codes to input from basics
Can we remove only duplicate data and keep distinct data in a row?
Sir , y did u sort d table? . Sorting was not ascending n descending. Wats d use of dis
Sir I have a question! how to add the quantity of the same duplicate and just one unique will display! For example duplicate value of
"1003","aaa", total qty: 4+7=11. And the expected output would like this. Is this possible sir?
yes, it is very much possible. for any project support in excel vba, please write to exceldestination@gmail.com
Tanks a lot teacher.
Welcome!!
Thank you, it works
i used to follow your tutorial compile error for without next why is this happening
Hi sir/mam
This is Siva Kumar, I used to follow ur videos tutorials. In VBA to delete duplicate rows scenario I have a doubt. This code is working when last row matches with last before row then it keeps remain one row and delete other row. It's not working when there is existence of last row in second r third row from top. This code executes from bottom. Am I correct? Please assist me how to resolve this. Thanks in advance.
Hi Siva...thanks for watching my tutorials...actually...I have tested this code at my end...and then uploaded this tutorial...there is a logic for running loop from bottom to top...and before loop...we need to sort data...so logic wise...first sorting of data...then count total lines...then running loop from bottom to top...in case you need any of my help in vba...please write to EXCELDESTINATION@GMAIL.COM....THANK AGAIN...and keep watching :)
K, thanks. I will try this again.
Yes only working on last rows matched value
Please update your code to remove duplicate row and sum quantity column.
For customer 1003 should be quantity 11
Hi Sir, My duplicate value is in column H, I changed the column but still duplicate are getting removed from Column A. Plz reply what mistake I am doing.
Let me check. can you share your file at exceldestination@gmail.com
At customer id 1003 there is different date, how if i want delete the old date and keep the new date
yes, you can do that
Not working I give error of 'next'
How to remove duplicate row with multiple worksheets & with multiple column without transfering data from one worksheets to other using VBA ???
Great job bro
works perfectly on on tab, not working when I create two buttons for two different tabs. Please help
you can try different buttons on different tab. Because if you use both buttons on one tab, some different code will be required for activating sheet etc.
not working
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