LinkBack URL
About LinkBacks
Question Solved
Remove duplicated data and inform user how many data have been removed using macro
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:04 PM.
Are the duplicate values in column E? Do you want to remove the entire row where duplicates are found?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Question solved
Last edited by SHELLY567; 01-15-2018 at 12:32 PM.
Hopefully, I have understood correctly what you want to do. Try this macro on a copy of your file.
Please Login or Register to view this content.
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:04 PM.
The macro doesn't seem to work
Deleted because OP complied to Forum Rules.
Last edited by bakerman2; 01-13-2018 at 07:30 PM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
First rule on deleting rows is to start from the bottom up to the top.
Does it matter which duplicate is removed ?
If possible post an example file which reflects the current situation so we have something to work with.
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:05 PM.
Mumps' code runs like this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
What if I do not want the entire row to be deleted? Meaning only duplicated rows in column E should be deleted.
Do you mean just the cells?Meaning only duplicated rows in column E
What does your data look like?
TryOriginally Posted by SHELLY567
Please Login or Register to view this content.
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:06 PM.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If it took long, you must have many formula.
Please Login or Register to view this content.
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:03 PM.
OK, then try this one
Please Login or Register to view this content.
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:03 PM.
That's impossible.
They looks duplicates, but I don't think they are.
Extra space or something.
If you uplocad that workbook, it will be cleare.
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:01 PM.
This is my first time that it doesn't work...
Seems need to run twice...
Please Login or Register to view this content.
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:00 PM.
Try this one
Please Login or Register to view this content.
Question Solved
Last edited by SHELLY567; 01-15-2018 at 12:00 PM.
Change to
Edit: one line deleted.Please Login or Register to view this content.
Last edited by jindon; 01-15-2018 at 08:54 AM.
Yea it works! Thank you! I wonder if there is a simpler code?
1) prepare helper column
2) concatenate A,C,D,E,F,G,H and I
3) Use Countif function
4) Autofilter by helper column to pick 2
5) hirite one of the visible cell and right click "Delete entirerow".
May take a long time,
What if I sort data into duplicated and non duplicated first and delete the duplicated data? I just want to make sure the macro is as short and simple as possible.
Shelly, please do NOT delete your posts in this - or any other thread. The forum is about people mutually helping each other, but now, any other member looking for assistance on a similar issue, will not be able to get any help from this thread.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks