Referencing the column of sheet

[muditbathwal621]

Hi All

I have a task to do in excel.

I want to copy the data from column A of Sheet1 to other column of Sheet2 in same workbook. But that macro should run automatically as soon as user enter the data in column A of Sheet1.

Experts comments as welcome.

Thank you.

Regards
Mudit

 

[ps1]

Why not have a formula in Sheet2 that refrences sheet1?

In Sheet2 Cell A1 have

=Sheet1!A1

and copy down

 

[muditbathwal621]

I want to do it in Excel VBA .