|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Import a nomefile contained in a cell into a formula contained in another cell (in the same sheet)
Hallo All!
Could you please help me with this: I have in cell A2 a formula: ='C:\Users\m.salerno\Documents\[Cost overview.xlsm]Financial'!$O47 This formula gives in cell A2 the content of the cell O47 in the sheet Financial of the file Cost overview.xlsm (that is a different file) Is it possible to indicate the name of the file (because the file name can change) in the cell A1 and automatically the formula import the file name ? I mean something like: ='C:\Users\m.salerno\Documents\[A1]Financial'!$O47 I tried but it doesn't work. Thanks! |
#2
|
||||
|
||||
Have a look at 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
|
|||
|
|||
Thanks for your reply!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FORMTEXT field contained in INCLUDETEXT bookmark | emwinschuh | Word | 1 | 08-17-2015 08:55 AM |
Prefilled email with information contained in a Word document | frlan2a | Word VBA | 4 | 09-05-2014 07:36 AM |
Conditional Formatting - color only dates contained in a range | EC37 | Excel | 1 | 07-08-2014 12:51 PM |
Word delete page if string is not contained | wolfking333 | Word VBA | 0 | 06-23-2013 10:02 AM |
Merging a Word doc with VB functions contained | adamwbrown | Word | 0 | 08-13-2008 06:10 AM |