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:

Please Login or Register  to view this content.

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).