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

Thnxs

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't 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 another spreadsheet table

Bakar