Many activities which are can be performed manually can be simulated with
code.

Naturally the code performs these actions much quicker than can be done
manually. It is hard to say if there is an opportunity to apply code (or
even formulas) in your case - but I would guess there is. Try checking out
this page and see if you see some useful ideas:


http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy



"Tufail" wrote:

hi all of you,
i am downlodaing evry day huge data from our inventory list, then i am
finding out myself new records as well as deleted records which taking too
long time,after checking i am keeping that result in other sheet i means
deleted and new records, is there any macro or other way that i could know
new data as well as deleted data ?
thanks in advance.