• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 104
  • Last Modified:

variable within reference string to other file

I am using a simple link from 1 file to another:  =[source0115.xlsx]Sheet1!$A$1

The file name is source0115.xlsx

I want to make that a reference so I can keep changing a reference cell in the destination sheet to pick up data from the correct month without having to find/replace.

I tried =[=C1]Sheet1!$A$1 where C1 was source0215 but it didn't work.

THANKS!
0
dnewman33
Asked:
dnewman33
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

=INDIRECT("'["&C1&"]Sheet1'!$A$1")

if the file is not currently open C1 should have the complete path of the file

your formula should be with path in C2

=INDIRECT("'"&C2&"["&C1&"]Sheet1'!$A$1")

Regards
0
 
dnewman33Author Commented:
Perfect! Thanks!!!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now