Hi All

In column A I have workbook names
A1=0001
A2=0002
....
In column B I trying find formula to find value from workbook columnA
Example:
B1=C1 from workbook (filename fromA1)
All these workbook in C:\My Documents

I hope you understand what I mine