Is there a macro to split the contents of an Excel spreadsheet into seperate spreadhseets?
Posted
by
Sean Chadwick
on Super User
See other posts from Super User
or by Sean Chadwick
Published on 2012-06-01T14:46:40Z
Indexed on
2012/06/01
16:43 UTC
Read the original article
Hit count: 336
I know there are similar questions out there but I don't think they are quite the same.
I have a 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?
© Super User or respective owner