Filling Formulas Across Workbooks

[Guest]

I'm am somewhat of a novice user when it comes to excel, so if my question
isn't really clear as to what I'm trying to do I apologize.

I have two spreadsheets. The first contains all the data we use regularly.
The second will contain some data from the first spreadsheet that we will
need to convert to a csv file to upload to a 3rd party program. When I
create a formula in the 2nd spreadsheet that retreives data from the 1st
(=[UNINV.XLS]RETAIL!$E$6) and I try to fill down so that the next cell will
be $E$7 it just copies the orginial formula ($E$6) all the way down the page.
I have filled down before when using a formula that only applies to the
workbook I currently have open. Can this be done? Can you fill down
formulas in a series across excel spreadsheets?

 

[Jim Rech]

Edit the dollar signs from the formula and it should be fine.

--
Jim
| I'm am somewhat of a novice user when it comes to excel, so if my question
| isn't really clear as to what I'm trying to do I apologize.
|
| I have two spreadsheets. The first contains all the data we use
regularly.
| The second will contain some data from the first spreadsheet that we will
| need to convert to a csv file to upload to a 3rd party program. When I
| create a formula in the 2nd spreadsheet that retreives data from the 1st
| (=[UNINV.XLS]RETAIL!$E$6) and I try to fill down so that the next cell
will
| be $E$7 it just copies the orginial formula ($E$6) all the way down the
page.
| I have filled down before when using a formula that only applies to the
| workbook I currently have open. Can this be done? Can you fill down
| formulas in a series across excel spreadsheets?