Hello all,
hoepfully you can help.
I am currently running daily uploads into our database, and the data provided to me is in a CSV format, and consists of around 20 columns (it's address data)
my issue is that if we're uploading to address types to a reference, column B needs to bo populated with a B, instead of a P.
now, column E is the reference, and column F is the address type (main or Corr)
i can obviously sort the cells absolutely fine, but i need either i way of quickly identifying the duplicates, and correcting Column B for the 'Corr' address, or some help in writing a macro for it.
many thanks, Karl
Bookmarks