| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q: Can a formula reference a cell to get the file name to link to for data?
I am attempting to simplifiy some template files I created for other non-Excel users. I would like to make it easier to have users update formulas, by having the formulas reference a cell for the tab or file to pull data from. Eample formula: COUNTIF(*_'DATAFILE.XLS'_*!$J$2:$J$8000,C4). I would like to repalce DATAFILE.XLS to reference a cell vaule. This way all formulas would ppoint to one cell where the user would type in the name of the file to use. Hope this makes sense.... Anyone ever try this? Thanks! -- mgarcia ------------------------------------------------------------------------ mgarcia's Profile: http://www.excelforum.com/member.php...o&userid=30584 View this thread: http://www.excelforum.com/showthread...hreadid=502342 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy formula down a column does not use correct cell reference | Excel Discussion (Misc queries) | |||
| Dynamically-linked formula, cell reference in the string | Excel Worksheet Functions | |||
| how to reference external refereces from a list | Excel Worksheet Functions | |||
| Reference to One Cell stays the same in Different Formula | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
