Copy columns and make new tab

I am trying to take the data from c1:L23 and create a new tab, paste the information in there and title the tab with the data that is in cell A1.

Any thoughts. VBA would be great.

Thanks in advance.

Hi Aehartle, perhaps the following VBA code will work for you:

Sub copydata()
Dim sName As String, ws As Worksheet
Set ws = ActiveSheet
sName = ws.Range("A1").Value
Sheets.Add.Name = sName
Sheets(sName).Range("C1:L23").Value = ws.Range("C1:L23").Value
End Sub

This doesn't account for any invalid characters in cell A1 that aren't permitted in Sheet names, nor does it check to see if a sheet with that name already exists (both of which will cause the macro to error).