Excel Shortcut Copying from a cell to Update Hyperlinks in MassExcel automatic hyperlinksHyperlinks in...
Make a Bowl of Alphabet Soup
Why is the Sun approximated as a black body at ~ 5800 K?
How does electrical safety system work on ISS?
Can you use Vicious Mockery to win an argument or gain favours?
Review your own paper in Mathematics
Mimic lecturing on blackboard, facing audience
What features enable the Su-25 Frogfoot to operate with such a wide variety of fuels?
Did the UK lift the requirement for registering SIM cards?
Why does Carol not get rid of the Kree symbol on her suit when she changes its colours?
Is there a nicer/politer/more positive alternative for "negates"?
Are Captain Marvel's powers affected by Thanos breaking the Tesseract and claiming the stone?
How do I fix the group tension caused by my character stealing and possibly killing without provocation?
Biological Blimps: Propulsion
What does Apple's new App Store requirement mean
Why Shazam when there is already Superman?
Circuit Analysis: Obtaining Close Loop OP - AMP Transfer function
What is Cash Advance APR?
Has the laser at Magurele, Romania reached a tenth of the Sun's power?
Is a Java collection guaranteed to be in a valid, usable state after a ConcurrentModificationException?
What kind of floor tile is this?
What is the English pronunciation of "pain au chocolat"?
Why should universal income be universal?
Merge org tables
What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?
Excel Shortcut Copying from a cell to Update Hyperlinks in Mass
Excel automatic hyperlinksHyperlinks in Windows Update window not working?How to easily copy hyperlinks in web pagesDocument links pointing to other .docx files are broken in a combined .pdf conversionCopying Excel Spreadsheet with Absolute Hyperlinks to Documents (change to relative?)How to add 2 hyperlinks in a single cell in Excel 2010?Multiple Hyperlinks to Multiple FilesAuto-hyperlinking in ExcelAutomatically applying hyperlinks from one cell to anotherExcel - Change hyperlinks
I have a spreadsheet with two columns: A & B. In column "A", I have product IDs. In column "B" I have the same product IDs listed (in the same order). I want each product ID in column "A" to link to a word doc saved on my computer. The word docs saved on my computer are titled with the product ID (exact). To save time, I hyperlinked the entire column "A" to link to the same word doc. Then, I want to copy the product ID from column "B" into the existing column "A" hyperlink and overwrite the generic/copied product ID that is already there. Overall goal, to click on the product ID in column "A" and have it open the corresponding word doc. I have been copying the product ID from column "B", right clicking on the product ID in column "A", edit hyperlink, paste product ID over the generic product ID in the hyperlink field. Doing this over 300 times is not a night of fun for me! Help!
hyperlink
asked 2 mins ago
Leslie Christiansen KillingerLeslie Christiansen Killinger
11
New contributor
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a spreadsheet with two columns: A & B. In column "A", I have product IDs. In column "B" I have the same product IDs listed (in the same order). I want each product ID in column "A" to link to a word doc saved on my computer. The word docs saved on my computer are titled with the product ID (exact). To save time, I hyperlinked the entire column "A" to link to the same word doc. Then, I want to copy the product ID from column "B" into the existing column "A" hyperlink and overwrite the generic/copied product ID that is already there. Overall goal, to click on the product ID in column "A" and have it open the corresponding word doc. I have been copying the product ID from column "B", right clicking on the product ID in column "A", edit hyperlink, paste product ID over the generic product ID in the hyperlink field. Doing this over 300 times is not a night of fun for me! Help!
hyperlink
asked 2 mins ago
Leslie Christiansen KillingerLeslie Christiansen Killinger
11
New contributor
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a spreadsheet with two columns: A & B. In column "A", I have product IDs. In column "B" I have the same product IDs listed (in the same order). I want each product ID in column "A" to link to a word doc saved on my computer. The word docs saved on my computer are titled with the product ID (exact). To save time, I hyperlinked the entire column "A" to link to the same word doc. Then, I want to copy the product ID from column "B" into the existing column "A" hyperlink and overwrite the generic/copied product ID that is already there. Overall goal, to click on the product ID in column "A" and have it open the corresponding word doc. I have been copying the product ID from column "B", right clicking on the product ID in column "A", edit hyperlink, paste product ID over the generic product ID in the hyperlink field. Doing this over 300 times is not a night of fun for me! Help!
hyperlink
asked 2 mins ago
Leslie Christiansen KillingerLeslie Christiansen Killinger
11
New contributor
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a spreadsheet with two columns: A & B. In column "A", I have product IDs. In column "B" I have the same product IDs listed (in the same order). I want each product ID in column "A" to link to a word doc saved on my computer. The word docs saved on my computer are titled with the product ID (exact). To save time, I hyperlinked the entire column "A" to link to the same word doc. Then, I want to copy the product ID from column "B" into the existing column "A" hyperlink and overwrite the generic/copied product ID that is already there. Overall goal, to click on the product ID in column "A" and have it open the corresponding word doc. I have been copying the product ID from column "B", right clicking on the product ID in column "A", edit hyperlink, paste product ID over the generic product ID in the hyperlink field. Doing this over 300 times is not a night of fun for me! Help!
hyperlink
hyperlink
asked 2 mins ago
Leslie Christiansen KillingerLeslie Christiansen Killinger
11
New contributor
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
Leslie Christiansen KillingerLeslie Christiansen Killinger
11
New contributor
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
Leslie Christiansen KillingerLeslie Christiansen Killinger
11
New contributor
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
Leslie Christiansen KillingerLeslie Christiansen Killinger
11
asked 2 mins ago
Leslie Christiansen KillingerLeslie Christiansen Killinger
11
11
New contributor
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Leslie Christiansen Killinger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Leslie Christiansen Killinger is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1416165%2fexcel-shortcut-copying-from-a-cell-to-update-hyperlinks-in-mass%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Leslie Christiansen Killinger is a new contributor. Be nice, and check out our Code of Conduct.
Leslie Christiansen Killinger is a new contributor. Be nice, and check out our Code of Conduct.
Leslie Christiansen Killinger is a new contributor. Be nice, and check out our Code of Conduct.
Leslie Christiansen Killinger is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1416165%2fexcel-shortcut-copying-from-a-cell-to-update-hyperlinks-in-mass%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
