#1
|
|||
|
|||
Getting value from another file
Hi,
Im trying to get value from cell A1 from file name XXX.xlsx The thing is that I hold name of this file in another cell. I give an example: File X.xlsx, I want to get value from file Y from cell A1. (same folder) formula: =[Y.xlsx]Sheet1!A1 but the name I want to get from cell: =[A1]Sheet1!A1 This way I get only string not value, the name of file is in cell A1 in string form. I hope u get it. Thanks for answer |
#2
|
||||
|
||||
Perhaps try the INDIRECT function ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Yes, I tried.
Could you give me an example ? |
#4
|
|||
|
|||
I would like to add that the file is closed.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to highlight repeated words in word file and extract into excel file | aabri | Word VBA | 1 | 06-14-2015 07:20 AM |
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? | commissarmo | Word VBA | 3 | 03-14-2015 12:53 AM |
Title bar in word and ecxel 2010 is not picking up greek file name of 2007 file | danielle | Word | 4 | 12-03-2014 07:47 AM |
excel cannot open the file .xlsx because the file format or file extension is not val | teddysika | Excel | 1 | 11-22-2012 06:06 AM |
error: You are attempting to save a file format that is blocked by file block setting | zatlas1 | Office | 8 | 04-28-2012 02:37 PM |