Excel links

Copper Contributor

I have an excel file that will always reverence the same cells in another excel file, but the file that is referenced will have a different name & part for different jobs.

 

M:\sales\Assembly\Internal EBZ Worksheets\00\[Doors_V5.xlsx] Path changes

 

Is there a formula that I can use here to use the path above plus this tab & cell "Overview'!$S$14"

 

i have many cells that the tab & cell number do not change, so I have been cutting & pasting the new path & file name into an old link.

 

3 Replies

Hi @gweak22;,

 

Looks like you are trying to lookup data from different sheet, you and use INDIRECT to get that information.. if are still having issue attach a sample file which will be help to show you in details 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

@Faraz Shaikh

 

Here is an example of the file that I use. 

Hi @gweak22 

 

Use the function Indirect function as showed below this should work fine

Snag_1f15d10c.png

 

Check the below video link that might be helpful how the sheet is dynamic, use the same logic to get you results.

https://youtu.be/ROym3e-S4OQ

 

Use the fu

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more