Thank you so much it works like a chart!
--
Thank you for your time!
John


"Jacob Skaria" wrote:

Sheets("DDS (2)").Name = Format(Now, "yyyy-mm-dd") & " " & Range("U2")

OR

Sheets("DDS (2)").Name = Format(Now, "yyyy-mm-dd_hh-mm-ss") & _
" " & Range("U2")


If this post helps click Yes
---------------
Jacob Skaria


"Very Basic User" wrote:

This code works fine with one exception. I only name the new tab with a date
and time stamp. In a cell "U2" the user selects shift too. What I would like
if for the code to read both the Date and the cell "U2" shift to name the new
tab. So end state I would see a tab named like this (01-01-2009 Shift 3) is
there any way to add that to this code. I hope this is enough information.

Thanks!

Sub SaveSheet()
SaveSheet Macro
Sheets("DDS").Select
Sheets("DDS").Copy Befo=Sheets(3)
Sheets("DDS (2)").Select
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("B1").Select
Application.CutCopyMode = False
Sheets("DDS (2)").Select
Sheets("DDS (2)").Name = Format(Now, "yyyy-mm-dd_hh-mm-ss")
Range("B1").Select
Sheets("DDS").Select
Range("B1").Select
End Sub

--
Thank you for your time!
John

--
Thank you for your time!
John