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