Link to home
Start Free TrialLog in
Avatar of dnewman33
dnewman33

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dnewman33
dnewman33

ASKER

Perfect! Thanks!!!