Deleting all matched values in a range

[Todd Huttenstine]

Hey guys

I have 3 columns of values. AD:AD, AE:AE, and AF:AF.
AD:AD contains employee names, AE:AE contains their title,
and AF:AF is a list of titles. AF:AF is a list of data to
find and delete in AE:AE and the corresponding cell in
AD:AD. In other words, I need a code that will look in
AF:AF and for each value it sees, it needs to find that
value in AE:AE and for each match it finds, it needs to
delete each value as well as the value corresponding value
in AD:AD. When it deletes the value it needs to delete
Shift:=xlShiftUp.


Thank you

Todd Huttenstine

 

[JulieD]

Hi Todd

first place to start is reading the info on duplicates that Chip Pearson has
on his website -
http://www.cpearson.com/excel/duplicat.htm

Cheers
JulieD