Formula fill across workbooks
 

I have been trying to get the formula fill to work across workbooks, but all
it does is copy the cells I am using as a start point. My data source is
nine cell on one work book (1 - 9), and I did a simple =[Book1]Sheet1!$A$1 in
the first cell o fwork book 2, followed by =[Book1]Sheet1!$A$2 and
=[Book1]Sheet1!$A$3 in the next two cells. It worked fine for the first
three cell, but when I tried to use the formula fill all it did was copy the
original three cells. What am I missing?

Formula fill across workbooks
 

You have too many $ signs.

=[Book1]Sheet1!$A$1

Change to =[Book1]Sheet1!$A1 and drag/copy down.

Column A will stay as A and row 1 will increment.

But your formula will not fill across workbooks.

It will only pull A1:A9 from [Book1]Sheet1 to Book2

What are you really looking for?


Gord Dibben MS Excel MVP


On Tue, 2 Feb 2010 10:01:01 -0800, blairake
wrote:

I have been trying to get the formula fill to work across workbooks, but all
it does is copy the cells I am using as a start point. My data source is
nine cell on one work book (1 - 9), and I did a simple =[Book1]Sheet1!$A$1 in
the first cell o fwork book 2, followed by =[Book1]Sheet1!$A$2 and
=[Book1]Sheet1!$A$3 in the next two cells. It worked fine for the first
three cell, but when I tried to use the formula fill all it did was copy the
original three cells. What am I missing?

Formula fill across workbooks
 

What i'm trying to do is have workbook #2 "mirror" the results in workbook
#1, without users being able to make any changes in workbook #1. Workbook #2
would have results from four or five other workbooks showing in it.

"Gord Dibben" wrote:

You have too many $ signs.

=[Book1]Sheet1!$A$1

Change to =[Book1]Sheet1!$A1 and drag/copy down.

Column A will stay as A and row 1 will increment.

But your formula will not fill across workbooks.

It will only pull A1:A9 from [Book1]Sheet1 to Book2

What are you really looking for?


Gord Dibben MS Excel MVP


On Tue, 2 Feb 2010 10:01:01 -0800, blairake
wrote:

I have been trying to get the formula fill to work across workbooks, but all
it does is copy the cells I am using as a start point. My data source is
nine cell on one work book (1 - 9), and I did a simple =[Book1]Sheet1!$A$1 in
the first cell o fwork book 2, followed by =[Book1]Sheet1!$A$2 and
=[Book1]Sheet1!$A$3 in the next two cells. It worked fine for the first
three cell, but when I tried to use the formula fill all it did was copy the
original three cells. What am I missing?

.

Formula fill across workbooks
 

In A1 of workbook #2 enter =[Book1.xls]Sheet1!$A1

Copy down as far as you wish.

In A2 enter =[Book2.xls]Sheet1!$A1

Copy down.

Follow the pattern for all other workbooks to be linked.


Gord


On Wed, 3 Feb 2010 11:08:01 -0800, blairake
wrote:

What i'm trying to do is have workbook #2 "mirror" the results in workbook
#1, without users being able to make any changes in workbook #1. Workbook #2
would have results from four or five other workbooks showing in it.

"Gord Dibben" wrote:

You have too many $ signs.

=[Book1]Sheet1!$A$1

Change to =[Book1]Sheet1!$A1 and drag/copy down.

Column A will stay as A and row 1 will increment.

But your formula will not fill across workbooks.

It will only pull A1:A9 from [Book1]Sheet1 to Book2

What are you really looking for?


Gord Dibben MS Excel MVP


On Tue, 2 Feb 2010 10:01:01 -0800, blairake
wrote:

I have been trying to get the formula fill to work across workbooks, but all
it does is copy the cells I am using as a start point. My data source is
nine cell on one work book (1 - 9), and I did a simple =[Book1]Sheet1!$A$1 in
the first cell o fwork book 2, followed by =[Book1]Sheet1!$A$2 and
=[Book1]Sheet1!$A$3 in the next two cells. It worked fine for the first
three cell, but when I tried to use the formula fill all it did was copy the
original three cells. What am I missing?

.