Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File names within formulae
Help - is it possible to reference data from another spreadsheet by using a
named range or otherwise within the formula? e.g. You want to retrieve data from cell A1 in another spreadsheet named "accounts january.xls" - you would normally type =c:\[accounts january.xls]'!A1. Each month the name of the spreadsheet source changes to "account february.xls" etc..etc.. This formula exists in many cells - is it possible to name this "changing" spreadsheet name by referencing all these formulas to one cell which contains the name of the spreadsheet source? e.g =c:\[=b2].xls'!A1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel file get error with file names that have spaces in the | Setting up and Configuration of Excel | |||
Using Worksheet names in formulae | Excel Discussion (Misc queries) | |||
EXCEL97 FILE NAMES TRUNCATED TO THE FIRST LETTER IN THE FILE NAME | New Users to Excel | |||
Can Named ranges be used in file link formulae? | Excel Worksheet Functions | |||
Formulae using range names | Excel Worksheet Functions |