I desparately need assistance with regards to creating a macro to sort the raw data I am recieving into a readable spreadsheet.
Specifically, the file attached named Unsorted Data is the data I am recieving and the file attached named Sorted Data is what I need the macro to accomplish. I need the code to use company name, website and email address from the unsorted data files and organise it as shown in the Sorted Data file.
Any assistance would be greately appreciated.
Regards