Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can someone help me out and explain (show an example formula) of how to use
Harlan's pull function? It sounds exactly like what I need, but I cannot get it to work. Below is what I have input into the cell which I need to recover data from a closed workbook. =pull("'"&ModelDir&"\[jointdefaults.xls]Defaults'!$C$21") am I even close? The spreadsheet is always named jointdefaults.xls and the folder path is obtained in the range ModelDir. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get an IF statement to pull a date range?? | Excel Worksheet Functions | |||
Can a worksheet pull from a specific cell value in a separate wrks | Excel Worksheet Functions | |||
Problems with PULL function, INDIRECT.EXT and so forth | Excel Worksheet Functions | |||
Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions | |||
Pull Down Menu Bar | Excel Discussion (Misc queries) |