hi
i want creat a macro that find duplicate data and not allow to download, i
means everyday i am downloading data from web and i am keeping in my
spreadsheet (i'm copying from web then doing paste in my sheet) and now i am
facing problam that duplicate data dowloading again and again, i want find
duplicate by A:A becoz there is Ref# always, my data range is A_col H_col ,
hopefull you got what i want say or what i want to make.

Thanks