hyperlink w/in excel loses reference
this is the situation
person cell id hyperlink
Adams b20 b20
Jones b50 b50
Zilch b99 b99
If I create a hyperlink at Zilch to Jones the hyperlink = b50
then if I add a person above Jones (b50), the Jones info moves down and...
I'm looking for a list of characters that are invalid in a hyperlink address (at least as far as Excel is concerned).
I have a form where the user can input a hyperlink address, and through VBA convert it to an active hyperlink. I've discovered that if the address has invalid characters (such...
i have two sheets.
Sheet 1 list contains orders & part nos.
While the other contains the part no which are in stock.
the format is as shown below.
Sheet 1
Order no Part
1001 x
1002 y
1003 z
1004 x
1005 a
Sheet 2
Part no Stock
x 1
y 1...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.