How to copy and sync to another sheet

[Opgelost]

Dear Friends,

I want to do the following:

I want to copy certain columns (A,B and D) from sheet 1 to sheet 2 and keep it always synced when I update the data in sheet 1. I will never enter date via sheet 2.

Kindly advise.

Thanks in advance.

 

[My Aswer Is This]

This script will keep Sheet(1) and Sheet(2) synced with all new data you enter in column("A") ("B") And ("D")
Put this script in Sheet(1)

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet(1) tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
If Target.Column = 1 Or Target.Column = 2 Or Target.Column = 4 Then
Target.Copy Destination:=Sheets(2).Cells(Target.Row, Target.Column)
End If
End Sub