I have two worksheet on the same workbook called sheet1 and sheet2.
I want data entered on sheet1 to automatically show on sheet2.
Example. "Sheet1"
C
C1 EMP ID
101
102
103
104
Now on "Sheet2"
C
C1 EMP ID
009
008
007
Now when i change 101 on sheet1 then "009" should automatically change to
101 Please can anybody advice on what to do. Thanks