Well...yes, why not?. If Find&Replace (in this case find 'Book1' and replace
with new workbook name) is not an option, you can reference the new workbook
name indirectly.
Let's say you use the formula in Book2 and your Book1 was renamed to Mybook.
WIth Find&Replace your formula would change to =[Mybook]Sheet1!A12&"
"&[Mybook]Sheet1!A13. If you don't want to change the formula, you could put
the name of the workbook into a separate cell (A1 in below example).
Assuming that A1 contains the text "Mybook" (without quotes) and Mybook.xls
is the workbook you want to pull data from, then your formula would have to
look like this:
=INDIRECT("["&A1&"]Sheet1!A12")&" "&INDIRECT("["&A1&"]Sheet1!A13")
Beware that Mybook.xls has to be open, otherwise your formula will produce
an error.
Joerg
Dave said:
Can this fomulation also be used with workbooks that have to have it's
name
changed on a daily basis?
Joerg Mochikun said:
=[Book1]Sheet1!A12&" "&[Book1]Sheet1!A13
Cheers,
Joerg
Dave said:
Hey All,
Don't know if this is the right group to ask this in.
Anyway, I'm trying to get info from multiple cells from workbook 1
sheet 1
cells A12 and A13 into worksheet 2 sheet 1 cell A5 with a space
between
the
2 info cells... is this possible or can you only get info from 1 cell
w/o
spaces??
