Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting data
Hi guys, I have a list of contacts, including email addresses. I have a list of email addresses (seperate from the main list) which want to delete from the main list, due to being out of date. Obviously want to remove these emails from the main list. Is there a macro that i can use which will delete the values from on colum in one sheet if they exist in another colum in another sheet?? Cheers -- blande ----------------------------------------------------------------------- blander's Profile: http://www.excelforum.com/member.php...fo&userid=3648 View this thread: http://www.excelforum.com/showthread.php?threadid=56657 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting data
For i = Cells(Rows.Count,"A").End(xlUp).Row To 1 Step -1 If Not IsError(Appliction.Match(Cells(I,"A").Value, Sheet2!Columns(1),0)) Then Rows(i).Delete End If Next i chnge the columns to suit -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "blander" wrote in message ... Hi guys, I have a list of contacts, including email addresses. I have a list of email addresses (seperate from the main list) which i want to delete from the main list, due to being out of date. Obviously i want to remove these emails from the main list. Is there a macro that i can use which will delete the values from one colum in one sheet if they exist in another colum in another sheet?? Cheers, -- blander ------------------------------------------------------------------------ blander's Profile: http://www.excelforum.com/member.php...o&userid=36486 View this thread: http://www.excelforum.com/showthread...hreadid=566578 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting data
Cheers, thankyou :) -- blander ------------------------------------------------------------------------ blander's Profile: http://www.excelforum.com/member.php...o&userid=36486 View this thread: http://www.excelforum.com/showthread...hreadid=566578 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fetching data and deleting original data | New Users to Excel | |||
MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
Deleting data | Excel Worksheet Functions | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) |