Quote:
Originally Posted by Bakar
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