Workbook to Workbook formula
 

=WordCountstest.xls!$A:$D

Why does this formula only show the top, left cel of my target data.
I am trying make rows A, B, C and D from one workbook called
"WordCountstest.xls" simply equal (or transfer or link) the same rows
on another workbook called Workbookdz.

?

Workbook to Workbook formula
 

Use

=WordCountstest.xls!A1

and copy down and across

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"dzelnio" wrote in message
oups.com...
=WordCountstest.xls!$A:$D

Why does this formula only show the top, left cel of my target data.
I am trying make rows A, B, C and D from one workbook called
"WordCountstest.xls" simply equal (or transfer or link) the same rows
on another workbook called Workbookdz.

?

Workbook to Workbook formula
 

No go.
It looks like this and still show only the top left cel.
=WordCountstest.xls!A1:D3000
Dave



On Jun 4, 9:37 am, "Bob Phillips" wrote:
Use

=WordCountstest.xls!A1

and copy down and across

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"dzelnio" wrote in message

oups.com...

=WordCountstest.xls!$A:$D

Why does this formula only show the top, left cel of my target data.
I am trying make rows A, B, C and D from one workbook called
"WordCountstest.xls" simply equal (or transfer or link) the same rows
on another workbook called Workbookdz.

?