Hi,
I am new to VBA code and this forum has been very helpful to me however I am struggling to find a solution to my latest problem anywhere...please can you help?!
I am currently using the code below to import a CSV file into an excel sheet call 'Raw Data'. I would like to update this code to prevent a CSV file being uploaded to 'Raw Data' if cell A4 in the CSV file matches an existing entry within column A of the 'Raw Data' sheet. If a record already exists then a message should be displayed saying something like "Record already exists, data has not been imported"
For reference I attach a copy
Thanks in advance, GraemePlease Login or Register to view this content.
Bookmarks