Aug 24 2020 12:26 PM
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.
Aug 25 2020 03:52 AM
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
Aug 25 2020 09:35 AM
Aug 25 2020 11:30 PM
Hi @gweak22
Use the function Indirect function as showed below this should work fine
Check the below video link that might be helpful how the sheet is dynamic, use the same logic to get you results.
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