Using Cell Values in Active Sheet to Populate Path to External Reference Link

wowcrofty · #1 12-19-2016, 10:24 AM

I have a sheet within a workbook which I would like to pull data from cells in another sheet which resides in another workbook. The formula to do this I have figured out, but instead of using a fixed path, I would like to use data from cells within the active sheet to populate the file path to the external sheet. Please advise on how I would be able to do this. Any way without using VBA would be preferred; however, I am fairly familiar with VB, so a programmatic approach is fine as well. Thank you in advance for any assistance.

gebobs · #2 12-19-2016, 11:05 AM

Try using INDIRECT.

wowcrofty · #3 12-19-2016, 11:14 AM

Thank you for the suggestion. How would I format the formula? Let me provide the link using my actual data.

Code:

='Z:\Financials\Sales\Cashier Return Sheets\FY2017\03\[week4.xlsx]Monday 1'!$C$50

Please let me know where to place the INDIRECT([cell name]) within the above formula.

gebobs · #4 12-19-2016, 11:44 AM

Perhaps it might help if you attached a sample sheet showing what you want to do.

wowcrofty · #5 12-19-2016, 12:29 PM

Please see the following files for the example. The first contains values to which the second will link.

File 1.xlsx

File 2.xlsx

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting autofilter criteria using columns and cells relative to the active cell in another sheet	SarahL	Excel Programming	7	06-11-2015 10:26 AM
Word: external reference from other documents	twinclouds	Word	6	03-12-2015 12:08 AM
Populate sheet 3 with data from sheet 1 and sheet 2	speck	Excel Programming	0	01-14-2015 07:54 AM
Reference another workbook and return values from the same cell across multiple sheets/tabs	lwls	Excel Programming	5	11-08-2014 02:11 PM
Reference to an external filename which changes frequently	roooberta	Word	0	12-11-2008 07:33 AM