Data should be appear same as 1sheet to another sheet

[Anantha Krishna]

Hello All,

Can any body help me for the below requirement.

I need vba code for below
If i put data on the sheet2, the same data should be appear on the sheet1 without click on run macro.

Eg.
Sheet2 if we have on column A
Jan
Feb
Mar

Sheet1 also appear same as column A
Jan
Feb
Mar

Regards,
Anantha krishna

 

[Marc L]

Hi !

Code to paste to Sheet2 module :​

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 1 Then Target.Copy Sheet1.Range(Target.Offset(, 1).Address)
End Sub

Do you like it ? So thanks to click on bottom right Like !
​

 

[Anantha Krishna]

Hi Marc,

Thank you so much for your solution.

I need some change, is it possible as below

Sheet2 if we have on column A
Jan
Feb
Mar

Sheet1 also appear same as column B
Jan
Feb
Mar

Regards,
Anantha Krishna

 

[Marc L]

Mod done in my previous post …​

 

[Anantha Krishna]

Hi Marc,

Yes, your code is working fine, but it is exact if data is in sheet2 columnA means it is appearing in column A.

But i need few change if i put data in sheet2 column A means it should be appear in sheet1 column B.

Eg.
Sheet2 ColumnA, columnB
Jan, Mon
Feb, Tue
Mar, Wed

Sheet1 Column A, column C
Jan, Mon
Feb, Tue
Mar, Wed

Regards,
Anantha krishna

 

[Marc L]

Again, mod already done in my first post …​