Dear Friends

I would like to use Excel file to keep tabular data and then to have a link to a text or doc file containing extensive information for each row.

Therefore I would like to have a column with cells containing links to files with extensive text information.

- If I enter, with a formula or by typing in, the text into a cell, it should turn into a link to a txt (or doc if possible) file.
- If the file already exists, the link is created, done.
- If it does not exist, the file is created. The file names can be duplicates.
- Relative path would be best for storing files. The files should be in the same folder as xls file or, preferably, in a subfolder. eg. data.

I tried numerous solutions and searched google, but I could not find anything working.

Thank you very much in advance for help or any indication.

Wishing you all the best

Jacek