Macros to delete duplicate entry
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 |
Quote:
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 |
Quote:
Thnxs 4 ur help I am actually transfering the data to another spreadsheet table Bakar |
All times are GMT +1. The time now is 07:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com