I am in dire need of help. I am creating a bulk mail list. I mailed to part of the homes in a zip code last month, now I want to send another postcard to homes in the same zip code, but not homes I've already mailed to. Is there any way to have excel compare my old list with my new one and delete any rows contained in both? Thank you.
Last edited by VBA Noob; 03-24-2008 at 10:30 AM.
If you're planning to move to Gainesville, FL, you need to visit our web site to search all of the Gainesville Real Estate for free. This is a great resource if you're planning to attend UF.
If the old list is on Sheet1 in column A and the new one is in Sheet2 column A, in sheet2, B1, =VLOOKUP(A1,Sheet1!A:A,1,False) and drag down. Then apply filters and filter column B to show everything but the error messages. These are the duplicates and can be deleted.
Thank You!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks