Vba to delete entire row of duplicate and original data entries

[GID1]

Hi

Can anyone help me out . I am having a hard time on this one. I would like to delete of entire row of the duplicate and original in column E whenever i enter duplicate in the Column E. Please kindly see the attached image. In the image i have two tables top is before and bottom table is after deleting the entire row of the duplicate and original in column E.


Thank you.

GD

 

[GID1]

Hi Alex,

Finally It works. Thank you so much. U r a genius. Cant believes finally someone solve it!!!!
Thanks Again. U r Great!!!

 

[Alex Blakenburg]

You are welcome. Glad I could help.

Would not have been able to work out what was happening without your post #9.

 

[GID1]

Well Sir, Thank you!!! God Bless!!

 

[GID1]

You are welcome. Glad I could help.

Would not have been able to work out what was happening without your post #9.

Hi Alex

Would you be able to pop up the value of any of cell in Column A in msgbox when the corresponding cell in column E becomes blank.

GID

 

[Alex Blakenburg]

If you mean on a row by row basis, if that happens a lot that will get really tiresome really quickly.
Why do you want the message box and what are you going to do with the information ? Do you want the sub routine to terminate as soon as it find a blank ?

 

[GID1]

If you mean on a row by row basis, if that happens a lot that will get really tiresome really quickly.
Why do you want the message box and what are you going to do with the information ? Do you want the sub routine to terminate as soon as it find a blank ?

Since column A cells has different location, whenever any of cells in Column E is deleted i would like to pop out a message saying "Please put back to location:value in Cell A" .
So meaning if cell E2 is deleted, i would like to pop out a msgbox from cell A2 to be displayed with a message above. These need to apply to any cells in both column A and E.
I don't know if this is possible. Please help me out if u know a way. Really appreciate your help.

 

[GID1]

Since column A cells has different location, whenever any of cells in Column E is deleted i would like to pop out a message saying "Please put back to location:value in Cell A" .
So meaning if cell E2 is deleted, i would like to pop out a msgbox from cell A2 to be displayed with a message above. These need to apply to any cells in both column A and E.
I don't know if this is possible. Please help me out if u know a way. Really appreciate your help.

The solution u provided previously is working perfectly.

 

[Alex Blakenburg]

Since column A cells has different location, whenever any of cells in Column E is deleted i would like to pop out a message saying "Please put back to location:value in Cell A" .
So meaning if cell E2 is deleted, i would like to pop out a msgbox from cell A2 to be displayed with a message above. These need to apply to any cells in both column A and E.
I don't know if this is possible. Please help me out if u know a way. Really appreciate your help.

You will need to open a new thread for this. I believe you are talking about needing a Worksheet Change Event.
In the thread you will need to clarify your requirement eg if E is deleted saying put back A doesn't seem to make sense, as A has not been removed.

Put a link to the new thread here and I can have a look tomorrow if noone else has helped you by then.

 

[GID1]

You will need to open a new thread for this. I believe you are talking about needing a Worksheet Change Event.
In the thread you will need to clarify your requirement eg if E is deleted saying put back A doesn't seem to make sense, as A has not been removed.

Put a link to the new thread here and I can have a look tomorrow if noone else has helped you by then.

no, sorry for not being able to explain correctly.
this is actually from the previous thread i posted and you gave me a solution on this. I just wanted to add on few more actions. After the duplicates are deleted off, i would like a pop out msgbox which will show the value of cell in Column A(Location) which is corresponding cell of the deleted duplicates.

Thanks a lot for your help and patience.