Re: Deleting all matched values in a range

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JulieD (julied_ng_at_hctsReMoVeThIs.net.au)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 21:59:51 +0800

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

"Todd Huttenstine" <anonymous@discussions.microsoft.com> wrote in message
news:1431901c4133a$2f89afc0$a101280a@phx.gbl...
> 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

Relevant Pages