Hello everyone please could someone take a look at a macro for me?
I have a list of letting agents that I need to sort into a table to import into Access. The list is dynamic in that not all the fields are present for every record.
I will have over 4000 records to sort out, so I would really like to automate this.
If possible the macro should read rows from the data worksheet and write to columns and rows on the Table worksheet.
I have attached a small example of the data and output required.
To make it a little more challenging the column header name is part of the data and will need stripping out as well.

Thanks for looking.

Regards
Andrew

Lettings Agents.xls