Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

variable within reference string to other file

Posted on 2014-12-10
2
73 Views
Last Modified: 2014-12-12
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
Comment
Question by:dnewman33
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40491347
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
 

Author Comment

by:dnewman33
ID: 40491442
Perfect! Thanks!!!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn the basics about Excel 2013’s new Flash Fill feature.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question