Formula fill across workbooks

[blairake]

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?

 

[Gord Dibben]

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

 

[blairake]

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.

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

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?

.

 

[Gord Dibben]

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

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.

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

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?

.