| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Import data from a different .xls file
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Import data from a different .xls file
Another way.
Open both workbooks Edit|copy the sending cell Go to the receiving cell Edit|Paste special|click the Paste Link button Excel will build the formula for you. On 05/18/2010 12:47, Ron_Marin wrote: I'm running Excel'97. Within the same directory I'm trying to import data into spreadsheet cell from a cell in a different .xls file. I've tried ='C:\Libraries\Documents\Spreadsheets\[Ron's_Budget_2010.xls]Expenses'!$A$2 but I get an error. Any ideas Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data from one file to another | Excel Discussion (Misc queries) | |||
| import data from txt file to an existing excel file | Excel Discussion (Misc queries) | |||
| Import File Data | Excel Worksheet Functions | |||
| Import data from zip file through Internet | Excel Discussion (Misc queries) | |||
| USING DATA FROM AN EXCEL FILE TO IMPORT INTO ANOTHER | Excel Worksheet Functions | |||
Linear Mode
