obtaining info from multiple cells from different workbooks.
 

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

obtaining info from multiple cells from different workbooks.
 

=[Book1]Sheet1!A12&" "&[Book1]Sheet1!A13

Cheers,
Joerg

"Dave" <Dave @discussions.microsoft.com wrote in message
...
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??

obtaining info from multiple cells from different workbooks.
 

Can this fomulation also be used with workbooks that have to have it's name
changed on a daily basis?

"Joerg Mochikun" wrote:


=[Book1]Sheet1!A12&" "&[Book1]Sheet1!A13

Cheers,
Joerg

"Dave" <Dave @discussions.microsoft.com wrote in message
...
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??

obtaining info from multiple cells from different workbooks.
 

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" wrote in message
...
Can this fomulation also be used with workbooks that have to have it's
name
changed on a daily basis?

"Joerg Mochikun" wrote:


=[Book1]Sheet1!A12&" "&[Book1]Sheet1!A13

Cheers,
Joerg

"Dave" <Dave @discussions.microsoft.com wrote in message
...
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??