Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 119
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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