Sub transfertJJ()
Dim derlg&, dercol&
On Error GoTo PasDeFeuille
With Sheets(Format([b1], "yyyy-mm-dd"))
.[b1] = [b1]
derlg = Cells(Rows.Count, "A").End(xlUp).Row
dercol = Cells(4, Columns.Count).End(xlToLeft).Column
Range("a4", Cells(derlg, dercol)).Copy .Range("a3")
End With
Exit Sub
PasDeFeuille:
MsgBox "Feuille " & Format([b1], "yyyy-mm-dd") & " inexistante", , "Information"
End Sub