Split Data into new Workbook

Hi All,

I currently have a macro which splits data of one sheet into seperate sheets depending on what column A states however i would like to change this so it creates a new work book saved in the same folder which the orginal spreadsheet is in named accordingly below is my current Macro:

Please Login or Register  to view this content.

Josrey, the macro you're citing above is from here:

Sheet1 to Many Sheets


If you find that in the PARSE section of the sidemenu, you'll find the alternate macro needed to parse Sheet1 to Workbooks.