I know there are similar questions out there but I don't think they are quite the same.
I have an excel spreadsheet with the following headings-
First name -- Surname -- Host Trust -- Contact details -- etc -- etc
It is a large spreadsheet. I have to send an email every week to host trusts to inform them of who will be working with them and it is a nightmare dividing this up manually.
Is it possible to create a macro which will split this spreadsheet into several spreadsheets using the the data from the
Host Trust column as the title of each spreadsheet?