You can use formulas to reference values in other workbooks:

=[AutoAmort.xls]Sheet1!$C$7

Generically speading:

=[WorkbookName.ext]SheetName!CellAddress
--
Kevin Backmann


"tel" wrote:

Is it possible for Excel to transfer data from one workbook to specific cells
in another workbook. I am using Office Home and Student 2007, do I need any
extra software?
--
tes