View Single Post
  #4   Report Post  
Old October 7th 08, 05:50 PM posted to microsoft.public.excel.worksheet.functions
carolj carolj is offline
external usenet poster
First recorded activity by ExcelBanter: Oct 2008
Posts: 3
Default using vlookup to delete duplicate data

Thank you for posting so quickly! Since my VB script is very rusty, I think
this is the way to go. I'll let you know how it works out.

"Sheeloo" wrote:

It appears that you want to delete from Sheet 2 those a/c numbers which are
on Sheet 1.

You can use VLOOKUP on Sheet 2 to mark those records, then you can filter on
NOT EQUAL To #N/A and delete those rows...

"carolj" wrote:

Can I use vlookup to find acct#'s on a second worksheet and have it delete
the rows of the acct#'s on the 2nd wksht that are returned?