Macros to delete duplicate entry

[Bakar]

Hi everyone
As usual thnxs for ur usual & valuable help
I need a macro to cancel or delete duplicate entry when transferin
data
example I have already run the transfer data macro and the data alread
transfered and I run again the same data is transfered again how t
delete or cancel the duplicate data with a macro

Thnxs

Baka

 

[Bakar]

Hi,

Where are you transferring the data to, i.e. Listbox or Spreadsheet?

If it is a listbox use listbox.clear method before updating new data.

For a spreadsheet there are several methods that can be used but I can'
suggest the best one until you are a bit specific on your requirement.

Prashant

Hi Prashant
Thnxs 4 ur help I am actually transfering the data to anothe
spreadsheet table

Baka