Re: Deleting excel rows based on multiple criteria

Suyog

If you are going to be doing this often you could write code, but, if
you are just doing it once, or only occasionally it should be pretty
easy to:

1. On the *** from which you want to delete the duplicates, use a
MATCH function to identify rows that should be deleted.

2. Sort that work*** so all the errors (#NA) get put together.

3. Delete those rows

4. Sort in original order. If the original order is important, you
need to make sure you can resort to regain that order before you
delete. You may need to insert a column and number the rows
sequentially so you will be able to return to te the original order
after youe delete.

If for some reason you won't be able to sort your data after marking
the duplicate rows with the MATCH function, you can use Go To Special
(F5) to select all the errors at once, then delete the entire rows all
at once.

Good luck.

Ken
Norfolk, Va

On Apr 17, 11:55 pm, suyog_linux <suyog.s...@xxxxxxxxx> wrote:
Hi All,

I am looking for hel to delete data from one of the huge excel file I
have.
Actually, I have two excel files, one contains data regarding Users
with UserName as primary key and other excel file contains some of
user ID's which also exist in first file.

I would like to get help with a VBA code which will take inputs from
one of the excel file search for that UserName in the file and delete
the whole row if UserName is matched.

Appreciating the help in this regard.

Thanks,
Suyog Shah

.

Loading