Private Sub FINAL_Click ()
Dim xsheet As Worksheet
Set xsheet = ActiveSheet
If xsheet.Name <> "Definitions" And xsheet.Name <> "fx" And xsheet.Name <> "Needs" Then xsheet.Range ("L2: L31" ). Copy
xsheet.Range ("C2: C31"). PasteSpecial Paste: = x IPasteAll, Operation: = xlNone, SkipBlanks:= False, Transpose: = False
End If
Application.ScreenUpdating = True
End sub
Private Sub Commandbutton1_click()
ActiveSheet.copy After:=Worksheets(sheets.count)
On Error Resume Next
ActiveSheet.Name=format(Date, "mmdd")
End Sub
Dim xsheet As Worksheet
Set xsheet = ActiveSheet
If xsheet.Name <> "Definitions" And xsheet.Name <> "fx" And xsheet.Name <> "Needs" Then xsheet.Range ("L2: L31" ). Copy
xsheet.Range ("C2: C31"). PasteSpecial Paste: = x IPasteAll, Operation: = xlNone, SkipBlanks:= False, Transpose: = False
End If
Application.ScreenUpdating = True
End sub
Private Sub Commandbutton1_click()
ActiveSheet.copy After:=Worksheets(sheets.count)
On Error Resume Next
ActiveSheet.Name=format(Date, "mmdd")
End Sub