Formula fill across workbooks


B

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

Advertisements

G

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
 
B

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.

Gord Dibben said:
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?

.
 
Ad

Advertisements

G

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.

Gord Dibben said:
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?

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top