Excel 2010 Macro -how to split worksheet into multiple files

[kbustin]

Hi there- I have a similar problem as DCS2010 from a post called 'Splitting a file into multiple files as per a column' - and I am not very good at VB. I got a macro to work called breakout but it split the data into multiple worksheets within the same workbook. I am looking for a macro that will split a worksheet into multiple workbooks or files based on a column. The column has about 50 customer names, so at each change in customer name, I would like a new workbook created and saved in the same folder as the original file. I would also like the name of the new workbook to be a combination of the header row for that column and the name in the column. Here is an example of the header row and data:

Example If Header Row is: 2012 P5 Time for and first company name is Tim Hortons then the File name should be 2012 P5 Time for Tim Hortons.xls
Can anyone help with this one?
Thanks!