| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use the content of a cell as part of filereference in other
I can't believe there is not an easy way to solve the following, but thusfar,
I've not been able to find it. Your help is much appreciated: I want to use the value of one cell to determine the filename that is used as a reference in a different cell: A1='\\....\[weekxx.xls]'Sheet1'!$C$15 Where xx is the value of Cell A2. So if A2=41, then the reference is to file week41.xl and A1 will be filled with the content of C15 in Sheet1 of that file If A2=42, the reference is to week42.xls etc. Anyone knows a solution that does not involve creating a macro? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing Part of a Cell's Content | Excel Worksheet Functions | |||
| display part of the cell content | Excel Discussion (Misc queries) | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| Can I search a cell for a value and extract part of content? | Excel Discussion (Misc queries) | |||
| vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
Threaded Mode
