Inputting data into two worksheets
 

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.

Inputting data into two worksheets
 

in sheet2 a2:

=Sheet1A1

copy across (and down) as required

"4762nicho" wrote:

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.

Inputting data into two worksheets
 

Typo ....

In Sheet2 ..

A2: =Sheet1!A1

"4762nicho" wrote:

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.

Inputting data into two worksheets
 

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

"Toppers" wrote:

Typo ....

In Sheet2 ..

A2: =Sheet1!A1

"4762nicho" wrote:

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.