sub macro1()
Dim ws As Worksheet
Set ws = Sheets("SEMAINE 0" & DatePart("ww", Date, 2, 2))
ws.Activate: Sheets.Add: ActiveSheet.Name = "Temp"
ws.Rows(1).Copy Sheets("Temp").[A1]
ws.Rows(ws.[A65536].End(xlUp).Row).Copy Sheets("Temp").[A65536].End(xlUp)(2)
Sheets("Temp").Columns.AutoFit
end sub