Forum Discussion
Dynamic Referencing to a closed workbook
Hi there, I am trying to create a formula that will dynamically pull in a cell's value from another workbook that is closed. I want to avoid manually referring to the source workbook, and instead...
Refresh an external data connection in Excel
Here are some untested examples, with formula and in VBA.
Although these examples are not tailored to your project, they may be of some help.
Don't think you can easily bypass VBA when it comes to closed workbooks.
I don't know of a safe way to do this without VBA, but if there is one, it's certainly more complicated than VBA.
| zip codes | location | ||||||||||
| 23456 | Test2 | Examble B2 formula: =INDEX('E:\ExcelForum\[postalcodes.xlsx]Sheet1'!$B:$B,MATCH(A2,'E:\ExcelForum\[postalcodes.xlsx]Sheet1'!$A:$A,0)) |
Hope I was able to help you with this info.
I know I don't know anything (Socrates)