i have a excel document which i would like to hyperlink. in column C i have 1 to 12,000 numbers with name and i want to hyperlink that 1 - 12,000 in the file which is the same name. i hope someone can help me because its very tedious to one by one hyperlink the 12,000. thank you so much,
Hyperlink PROBLEMS
-
-
-
Re: Hyperlink PROBLEMS
Attach a sample workbook for us to work with, please.
-
Re: Hyperlink PROBLEMS
Here it is. that is my excel file which i want to hyperlink the column 3, as you can see i already started the hyperlinking 1 by 1 and its very tedious. i hope you can help me. i have a 1 folder here on which i link the file. the file is in pdf format.
-
Re: Hyperlink PROBLEMS
I see no PDF file names or hyperlinks in that file - please tell me which cells to look at.
-
Re: Hyperlink PROBLEMS
for example this, i filter all the mechanical. in the column C i have an RFI number, and that RFI number is have a corresponding pdf. file, i didn't attach the pdf file because its big MB, that pdf. file is the same name in excel. and that is many with different RFI number and PDF doc.
-
-
Re: Hyperlink PROBLEMS
OK - I see now. What I would do is copy that column of PDF names to a second sheet, and then in column B drag down this formula:
=HYPERLINK("Mechanical\Erection"&A1&".pdf",A1)
You can then copy your links back into the column required.
Hope this helps!
-
Re: Hyperlink PROBLEMS
i did what you've said but it meesage me an error.
-
Re: Hyperlink PROBLEMS
my hyperlink folder is in desktop
-
Re: Hyperlink PROBLEMS
I can't read the screenshot, sorry, but it looks like you missed one of the speech marks ("). Or maybe there's a trailing space in the cell? Check after the final bracket (brace) that there isn't a space.
You will need to change the file location to whatever is correct (I was using what was in your attachment) before dragging down.
-
Re: Hyperlink PROBLEMS
here is the location of folder C:\Users\heral\Desktop\Mechanical\Erection
-
-
Re: Hyperlink PROBLEMS
OK, so substitute that in my formula!!!
=HYPERLINK("C:\Users\heral\Desktop\Mechanical\Erection"&A1&".pdf",A1)
-
Re: Hyperlink PROBLEMS
yey! thanks a lot, anyhow, is there's a way to change that link name to that number corresponding because the link goes this way [TABLE="width: 465"]
[tr]
[/tr]
[TD="class: xl67, width: 465"]C:\Users\heral\Desktop\Mechanical\Erection\RFI-MCC-M-7538.pdf[/TD]
[/TABLE] -
Re: Hyperlink PROBLEMS
thanks! it works!. anyhow, how to change the linked file without removing the link
-
Re: Hyperlink PROBLEMS
You have obviously done something wrong - please attach your file and I'll fix it for you. My formula, if used correctly, will give just the name as the link.
-
Re: Hyperlink PROBLEMS
Quote from krazeenookie;775427thanks! it works!. anyhow, how to change the linked file without removing the link
Eh??? :confused:
-
-
Re: Hyperlink PROBLEMS
here, i did edid the last portion formula you gave to me, but it work, anyhow i want to change that name to the name itself not the location. thankss
-
Re: Hyperlink PROBLEMS
You missed the last bit of the formula. Use this and copy down:
=HYPERLINK("C:\Users\heral\Desktop\Mechanical\Erection"&A1&".pdf",A1)
Why did you edit the last portion of the formula I gave you???
-
Re: Hyperlink PROBLEMS
sorry, okay ill do it again
-
Re: Hyperlink PROBLEMS
it give me error
-
Re: Hyperlink PROBLEMS
It does not give me an error. See attached!
By the way, the occasional "Thank you, but ..." would not go amiss. :wink:
-
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!