Hi,
not sure if this is possible. I want to automatically create a hyperlink in a cell where data is entered. In the attached sheet there are 2 columns, A with file numbers and B where a "Yes" can be typed if the file is present. What I want to do is enter a Yes, but have this automatically turn into a hyperlink using the file number in column A as part of the link to a .pdf of the same name.
Appreciate any help.
If you want to actually replace the Yes you will need to use VBA code. A simpler solution that may meet your needs is this formula starting in C2, then copy down:
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Hi,
yes, it would be the easy way to go alright, but unfortunatley I can only work with columns A and B because it is a controlled documnet and any additional columns are not allowed.
Here is a macro solution. boylers75=replace Yes with hyperlink when entered=Hyperlink.xlsm It assumes that the PDF file is in the same folder as this Excel file.
That waorks great, but the hyperlinkl need to work to a different folder, "\\TUGALW-FP02\DEPT\VE\Returned\". How does this get put into it, tried in vain
What did you try? Try this modification, although I haven't tested it because the destination is a network drive:
Please Login or Register to view this content.
Just realised I was referencing the wrong locatin which is why it was throwing up the error. Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks