|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Cell Values in Active Sheet to Populate Path to External Reference Link
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. |
#2
|
|||
|
|||
Try using INDIRECT.
|
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Perhaps it might help if you attached a sample sheet showing what you want to do.
|
#5
|
|||
|
|||
Please see the following files for the example. The first contains values to which the second will link.
File 1.xlsx File 2.xlsx |
Tags |
excel 2013 formula |
|
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 |