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.