using vlookup to delete duplicate data
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...
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?