Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Sorting Data into specific cells automatically

0

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

Answer
Discuss



Answer the Question

You must create an account to use the forum. Create an Account or Login