delete duplicated rows based on a criteria in another column

**melody10** · 10-07-2013, 09:02 AM

hi i need a macro that will delete all duplicated data in column A AND is blank in column F and then add the data in column AB..

Column A contains the order number...
Colunm F contains reference number...
Column AB contains number of pcs

What I need is that when there are the same order number with blank reference number, the number of pieces will be added into one cell..

confusing? i know.. in the attached is an example...

in column A there is 8 rows with the same order number and column F is all blanks... what i need is just to create this in one line and column AB will be the total of the 8 rows.

all these logic will be applied to all the same data in column A and with blank cells in column F. in my attached file there is a before and after sheet.. i have highlighted the outcome that i wanted.

I hope somebody could help me on this

**melody10** · 10-07-2013, 10:27 AM

any help please?

**alansidman** · 10-07-2013, 10:33 AM

Bumping your thread after 1 hour and 20 minutes is a little bit hasty. We encourage users to wait at least 24 hours before bumping threads. We have many users worldwide across many time zones. Please have a little patience. The more convoluted your request, the longer it takes to develop a valid solution.

Here is what our rules have to say on the matter.

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

**MickG** · 10-07-2013, 10:51 AM

Try this:-
Run code on "Before sheet"
NB:- This code will Modify your data sheet.

Please Login or Register  to view this content.

Regards Mick

**melody10** · 10-08-2013, 04:11 AM

thank you very much mick!!!

**MickG** · 10-08-2013, 06:53 AM

You're welcome
Regrds Mick

delete duplicated rows based on a criteria in another column

LinkBack

Thread Tools

Rate This Thread

Display

delete duplicated rows based on a criteria in another column

Re: delete duplicated rows based on a criteria in another column

Re: delete duplicated rows based on a criteria in another column

Re: delete duplicated rows based on a criteria in another column

Re: delete duplicated rows based on a criteria in another column

Re: delete duplicated rows based on a criteria in another column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to find and delete rows based on criteria within a given column

Delete Multiple Rows Based on Criteria in 1 Column

Delete Rows In Sheet 1 Based Off Of Criteria On Sheet 2 Column A

Delete Rows Based on Column Criteria

Delete Rows based on criteria in Column A (not working)

Bookmarks

Bookmarks

Posting Permissions