I would like to set up a spreadsheet that has links to other documents. I know how to create links, but I would like a link which contains a document location which can vary with a cell contents.
for exam if the file names were Report wk42, report wk43, report wk44 etc. and the cell I wanted a link to was D121 for example for each sheet. How do I create a query that will look at a cell which contains a wk. number which is selected by the user and changes the link/file name to the appropriate week and copy the correct data?
Any help would be much appreciated
for exam if the file names were Report wk42, report wk43, report wk44 etc. and the cell I wanted a link to was D121 for example for each sheet. How do I create a query that will look at a cell which contains a wk. number which is selected by the user and changes the link/file name to the appropriate week and copy the correct data?
Any help would be much appreciated
