| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a txt string to refer to other work book
Using
LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))) in conjunction with the SUBSTITUTE command, I can generate a txt string showing the path to a cell on an unopened work book, but I dont know how to use this sting to actually retrieve data from that cell !?!? Is there something like the value command I can use? I really would appreciate any help in this matter .. Thanks in advance Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Grouping Data to New Work Book | Excel Discussion (Misc queries) | |||
| Work Rota - Do I need a formula? | Excel Discussion (Misc queries) | |||
| it says "disk is full" when I try to save my excel work book | Excel Discussion (Misc queries) | |||
| master select page field for many pivots in one work book | Excel Discussion (Misc queries) | |||
Linear Mode
