Hi,

I have a workbook with approx 50 tabs. Call called something like N84001, N84002 etc... so not Sheet 1, Sheet 2 etc...

What I need is an easy way to save this file and split each type into a seperate Excel file.

I have tried some VBA and Macros but can not get it to work.

Anyone got a simpletons step by step guide on how to do it using Excel 2010?

Thanks
Will

Sorted it.

Used the following code:

Sub BreakItUp()
Dim sht As Worksheet
Dim wbk As Workbook
For Each sht In ThisWorkbook.Worksheets
Set wbk = Workbooks.Add
sht.Copy Before:=wbk.Sheets(1)
wbk.SaveAs "c:\" & sht.Name & ".xls"
wbk.Close
Set wbk = Nothing
Next
End Sub

I wrote a script that does just that (split excel worksheets into separate files) for my client, it's available for download online. Google "JMC Excel Split"

jeeshenlee dot com