Copy data to another spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JIm - 09 Feb 2007 04:05 GMT

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,

Reply to this Message

Teethless mama - 09 Feb 2007 05:07 GMT

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

or
=Sheet1!A1

> 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,

Reply to this Message

Max - 09 Feb 2007 11:28 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message