Copy data to another spreadsheet

[JIm]

I currently have to copy and paste data from one spreadsheet to another. Is
there a formula that I can write that would automatically copy the data that
I enter in a cell on spreadsheet one to a corresponding cell on spreadsheet
two.

Thanks,

 

[Guest]

Hold Shift key and select Sheet2
When you type in sheet1 it also enter in sheet2

or
=Sheet1!A1

 

[Guest]

You could also link cells across sheets in this manner ..

In Sheet2,

Put in B2:
=IF(Sheet1!B2="","",Sheet1!B2)

Copy B2 across and fill down as required
to link to the corresponding range in Sheet1