| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking to another file using file reference typed cell
I have a formula such as:
=COUNTA('C:\Accounting\[5010 Advertising.xls]Sheet1'!$C$209:$C$239) I was wondering if there is a way for example to put in cell A10: C:Accounting\[5010 Advertising.xls]Sheet1 and then in cell B10 use some sort of concatenation formula or something to create the COUNTA function by referencing the value (ie filename) in A10 ie: =CountA(&A10&C209:C239) ... but that is not it and I cant figure it out. Thank you for your help. Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell reference to another file | Excel Worksheet Functions | |||
| Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
| Change of File name within a cell reference | Excel Discussion (Misc queries) | |||
| linking a file to another linked file in excel | Excel Discussion (Misc queries) | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
Threaded Mode
