Hi,
I have a column with cells relating to job numbers(consecutive); each job number relates to a pdf file which contains full job descriptions and I use the table as a progress summary. When a user puts a new job number into a cell how do I get excel to ask them to hyperlink that cell to the related job? or alternatively the jobs are all named DCK 0001, DCK 0002 ... and are kept in the same folder is there a way to automatically create a hyperlink to the file when the job number is entered?
Regards,
Andy
Bookmarks