Create files from excel list

[moretvicar]

Hi All
Is it possible to crate multiple worksheets from a list of cells?

Eg in cells A1 to A12 I have various different dates (using . as the separator).
I would like to create a workbook named as each of these dates in the same folder as the original workbook that contains the list - can it be done?

[humdingaling]

yes

though you need to be clear about whether you are talking about multiple worksheets or workbooks?

[Catman50]

Hi Moretvicar

I have attached a workbook with the code to do this.

[moretvicar]

Sorry I meant to say create workbooks ie a new file for each cell value.

[humdingaling]

catman50's file should do just as you asked