Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filling Formulas Across Workbooks
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? |
#2
|
|||
|
|||
Edit the dollar signs from the formula and it should be fine.
-- Jim "BClifft" wrote in message ... | 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheets with formulas between different workbooks | Excel Discussion (Misc queries) | |||
Updating Old Workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
References to open/hidden workbooks become hard-coded in formulas - 2003 | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |