Inputting data into two worksheets

[Guest]

I want to input data into worksheet 1 in cell a1 and i also want the same
data to go into worksheet 2 but in cell a2. i would also like any other data
inputted to go across automatically eg sheet 1 a1 into sheet 2 a2, then sheet
1 b1 into b2 and so on. any ideas would be greatly appreciated.

 

[Guest]

in sheet2 a2:

=Sheet1A1

copy across (and down) as required

 

[Guest]

Typo ....

In Sheet2 ..

A2: =Sheet1!A1

 

[Guest]

thank you that was much appreciated that has just halved my work