This formula on any sheet would make the cell equal to Sheet 1 A1

=Sheet1!A1

Mike

"ollie" wrote:

could any body tell me if it is possible to create a formula that allows you
for example to input a number in worksheet 1 and for that number to
automatically appear in worksheet 2?