formula to pull info from one workbook to another

[chriscim]

at work i fill in different workbooks with info from printed reports - in the workbooks most of the info i put in is needed in another workbook
is there a formula to pull a cell answer to another workbook
ex:
workbook txu - a1 is 3:15
need it also in workbook jfc at c3

what is the foumula to get this to work
i know how to pull between multiple sheets on the same workbook but not between workbooks

thanks
chris

 

[Aladin Akyurek]

On 2002-04-24 09:05, chriscim wrote:
at work i fill in different workbooks with info from printed reports - in the workbooks most of the info i put in is needed in another workbook
is there a formula to pull a cell answer to another workbook
ex:
workbook txu - a1 is 3:15

need it also in workbook jfc at c3

what is the foumula to get this to work
i know how to pull between multiple sheets on the same workbook but not between workbooks

thanks
chris

How about something like that you enter in C3 in target worbook:

='[txu.xls]Sheet1'!$A$1
This message was edited by Aladin Akyurek on 2002-04-24 09:13

 

[chriscim]

thanks
works great
i love this site
and the people out there
with all the answers

thanks
chris