Copies The Sheet / Page And Creates A Sheet / Page Dated Yesterday And Assigns The İnformation İnto İt Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub Add_Sheet() Dim wSht As Worksheet Dim shtName As String shtName = Format(Now - 1, "dd.mm") For Each wSht In Worksheets If wSht.Name = shtName Then MsgBox "Sheet already exists...Make necessary " & _ "corrections and try again." Exit Sub End If Next wSht Sheets.Add.Name = shtName Sheets(shtName).Move After:=Sheets(Sheets.Count) Sheets("Ana_Sayfa").Range("A2:F50").Copy _ Sheets(shtName).Range("A1") End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 copies the sheet / page and creates a sheet / page dated yesterday and assigns the information into it 2 excel operators hk 3 prints all sheet / pages with data or scans but does not print 4 specify the number of copies to print from the printer 5 if the sheet / page is blank, inserts the date in the footer and prints if not 6 Print Custom Pages: You can use this code to print a range of custom sheet / pages instead of using the setting from the print options. Suppose you want to print sheet / pages 5 to 10. Just run this VBA code and enter the start sheet / page and end sheet / page. 7 font size and character in cell a1 only when sending to the printer in arial-italic and 14 points 8 prints the active sheet / page 9 prints cells with data 10 only printing cell a1 11 number of sheet / page prints with message box (prints even if the sheet / page is blank) 12 printing selected data with option button 13 print without preview 14 print-out a5 paper without preview 15 right mouse on active sheet / page menu 16 copies the same sheet / page as the active sheet / page. 17 copies and duplicates the active sheet / page with the active month name and year 18 remove sheet / page protections 19 opens sheet / page by month name and copies active sheet / page 20 header in the active sheet / page "my report" writes "takes from a1" (14 points)