Copy data to another spreadsheet
 

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,

Copy data to another spreadsheet
 

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

or
=Sheet1!A1


"JIm" wrote:

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,

Copy data to another spreadsheet
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JIm" wrote:
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,