software

I've got a spreadsheet listing details of reports, which are named
sequentially. e.g. report_01, report_02 etc.

The files are named similarly, and i'd like the doucment names to link to
the files

So what i'd like to do is quot;series fillquot; the hyperlinks. i.e. if i link
report_01 to the location of quot;report_01.docquot;, then the other cells can be
filled in automaticlly just changing the last 2 characters of the filename.

Is there a way to do this, or to set up a formula which correlates the link
location to a string in a cell, adding relevant bits (i.e. c:/folder/ and
..doc)

many thanks for any replies.

Hi, I'm not an expert but maybe something like:

=HYPERLINK(INDIRECT(quot;A1quot;)amp;TEXT(ROW(1:1),quot;00quot;)amp;quot;.DO Cquot;,INDIRECT(quot;A1quot;)amp;TEXT(ROW(1:1),quot;00quot;)amp;quot;.DOCquot;)
copy down
use A1 to enter the relevant information

HTH
JG

quot;Mattquot; wrote:

gt; I've got a spreadsheet listing details of reports, which are named
gt; sequentially. e.g. report_01, report_02 etc.
gt;
gt; The files are named similarly, and i'd like the doucment names to link to
gt; the files
gt;
gt; So what i'd like to do is quot;series fillquot; the hyperlinks. i.e. if i link
gt; report_01 to the location of quot;report_01.docquot;, then the other cells can be
gt; filled in automaticlly just changing the last 2 characters of the filename.
gt;
gt; Is there a way to do this, or to set up a formula which correlates the link
gt; location to a string in a cell, adding relevant bits (i.e. c:/folder/ and
gt; .doc)
gt;
gt; many thanks for any replies.