I have a sheet that is used to track excel sheets on our sharepoint.
As an example i have included example link ='http://intranet/commercial/Product Vault/[FG040164.xls]'!$C$11
My question is, is there a way to substitute [FG040164.xls] with a value that is kept in column A, so that i can autofill all future links
ie
FG123456 ='http://intranet/commercial/Product Vault/[FG123456.xls]'!$C$11
thanks in advance
Bookmarks