After Data Entry İnto Cells Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Target.Offset(1, -1).Select If Target.Column = 3 Then Target.Offset(1, -2).Select If Target.Column = 4 Then Target.Offset(1, -3).Select If Target.Column = 5 Then Target.Offset(1, -4).Select 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 after data entry into cells 2 excel operators hk 3 After entering data into a1 divided by 100 4 receive a message after each data entry 5 Adds sheet / pages based on data in column A and writes data up to column D 6 specify the number of copies to print from the printer 7 Fetch last row and column number 8 a3: prints data between cells f15 9 Allow data entry and other operations only to cells that have been used so far 10 identifying unique (single) data entries 11 inserts the date and time when data was entered into the cells where data was entered on the active sheet / page as a comment 12 number of sheet / page prints with message box (prints even if the sheet / page is blank) 13 importing data into the listbox 14 prints cells with data 15 do sorting into protected cells? 16 Input data into A1 with inputbox 17 auto-fit data into cell 18 importing data from the listbox into a worksheet 19 conditional data entry into textbox 20 pdf preview