| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display contents of cell in another workbook
Hi all
What am I missing ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Displays the contents of C111 IN WORK BOOK "Tour Managers Spreadsheet.xls"tour managers spreadsheet =("'"&LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A$1))-25)&"Road Managers Package\[Tour Managers Spreadsheet.xls]Tour Managers Spreadsheet'!C111") Just displays the text of the formula and not the contents of the C111 CELL LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A$1))-25) Gives me C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\ All Help Welcome Stew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Big Cell Contents - I don't want them to display | Excel Discussion (Misc queries) | |||
| Cell contents don't display everything entered? | Excel Discussion (Misc queries) | |||
| display contents of cell | Excel Discussion (Misc queries) | |||
| How do I display contents of an adjoining cell? | Excel Worksheet Functions | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
Threaded Mode
