Forum Discussion
Adding a hyperlink to another excel spreadsheet
Richard105 Hi. could you please elaborate a bit what you exactly want. I went through the sheet but couldn't get the issue.
If you could share a single example using the cell addresses, that'd be much helpful
thanks
Hi what im trying to do, and have had working to an extent is auto populate the snapshot below based on the file originally attached. what the macros within the attached file does is open this insert the required data to the next available line. but what im having to then do is manually add a hyperlink to the job number column so the attached file can be opened from this sheet.
Also as these files will be all over in lots of job folders im also trying to have the file name as a variable on the macro (not fixed as current) as sometime if these get moved or saved as something differently it loses the link (make it fool proof for other users)
not sure if that make any more sense?