Ok so thanks in advance I dont even know if this is possible I am trying to use a string of numbers in a cell to reference another excel file
kind of like this
='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[704241.xls]Sheet1'!$B$25
but with the ability to change the file name without having to reference file everytime its is changed if that makes sense.
so heres the what I need
book 1
cell
a1=704241 ='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[704241.xls]Sheet1'!$B$25
but then i change it to
a1=802123 ='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[802123.xls]Sheet1'!$B$25
and it is updated with the file.
kind of like this
='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[704241.xls]Sheet1'!$B$25
but with the ability to change the file name without having to reference file everytime its is changed if that makes sense.
so heres the what I need
book 1
cell
a1=704241 ='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[704241.xls]Sheet1'!$B$25
but then i change it to
a1=802123 ='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[802123.xls]Sheet1'!$B$25
and it is updated with the file.