I have a list if data that comes off a text based property list. I haven't done any macro development but I need a macro that make a new worksheet in the Excel File, copies data from one worksheet and pastes it into the appropriate column in a new worksheet.
Attached is a sample of the text list pasted into excel. The list pasted into Excel has 13,740 rows.
Below is a layout I'm trying to get this data formatted into in a 2nd worksheet.
Sale date Case# Opening Bid Lender Address Attorney
6/1/2013 12345 50,000 Avenue Mortgage 1 Main St, My Town John Lawyer
How do I write this macro?