| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Designating a workbook reference base on a cells contents
I saw this in another post and I thought that if it was reworded, it might
make it easier to understand. In the formula below, at the point where it says "Book2.xls", I was wondering if there would be a way to have "2" designated by the contents of a cell in the current worksheet. For example, A1 contains 2. It could be any number, but I want the file reference to change based on the contens of A1. Is this possible? ='C:\temp\[Book2.xls]Sheet1'!$D$1 Thanks, Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Swap contents of two cells | Excel Discussion (Misc queries) | |||
| Excel should be able to map which cells reference each other. | Excel Worksheet Functions | |||
| Clearing the Contents of Merged Cells | New Users to Excel | |||
| Excel should have the option to merge contents when merging cells. | Excel Discussion (Misc queries) | |||
Threaded Mode
