Reference sheet1 data in sheet2 using VBA

[ACCA369]

Hi,
I understand we can use Excel directly for reference sheet1 in sheet2 directly
Here, I want - Using VBA Could you pls help me to
1) Sheet 1 A:A data need to be referenced in Sheet 2 in A:A range

2) whenever I entered data in Sheet 1 - A:A columns, the same data has to be get populated in Sheet 2 - A:A column

Sample ( Sheet1 A:A).
10
20
15
0
34
36

Answer would be as below in
---- sheet2 A:A column
Sample
10
20
15
0
34
36

 

[Joe4]

Duplicate to: VBA - link sheet 1 and sheet 2 with autofill formula in sheet 2

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.