offset and records
 

hi
i am trying to do some work on adatabase in excel
below is an example of the database.
C D E
index title author
2 1000 c:/test.kevin mel
3 1001 c:/test.kevin1 john
4 1002 c:/test.kevin2 paul
5 1003 c:/test.kevin3 kevin
6 1004 c:/test.kevin4 mel
7 1005 c:/test.kevin5 john

the index is automatically assigned when file name is added to
database.
the title is a hyperlink to an external file.

what i want is for the user to be able to select the title and the
entire record will then be copied to another set of cells

thanks in adavnce

kevin