Home

Hyperlink Copy

%3CLINGO-SUB%20id%3D%22lingo-sub-790732%22%20slang%3D%22en-US%22%3EHyperlink%20Copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790732%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20trouble%20copy%2Fpasting%20hyperlinks.%20For%20example%2C%20in%20the%20mock%20worksheet%20attached%2C%20I%20have%20supplier%20names%20listed%20in%20column%20C%20of%20sheet%201.%20In%20the%20real%20file%2C%20I%20have%20thousands%20of%20these%20supplier%20names%20in%20which%20I%20want%20to%20create%20hyperlinks%20that%20route%20to%20sheet2%20column%20B.%20My%20issue%20is%20that%20when%20I%20try%20to%20copy%20a%20hyperlink-%20say%20C3%20from%20sheet1%20down%20to%20C4%2C%20the%20friendly%20name%20on%20C4%20changes%20to%20the%20friendly%20name%20of%20C3.%20When%20pasting%2C%20I%20need%20each%20supplier%20name%20to%20remain%20their%20name%20and%20not%20transfer%20to%20another%20supplier%20name.%20My%20goal%20is%20that%20I%20need%20to%20be%20able%20to%20click%20and%20drag%20the%20hyperlinks%20on%20the%20supplier%20name%20column%20all%20the%20way%20down%20while%20the%20supplier%20names%20maintain%20their%20names.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20willing%20to%20try%20a%20macro%20(although%20not%20my%20preference%20bc%20I%20have%20little%20to%20no%20knowledge%20of%20macros).%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20clarify%3A%3C%2FP%3E%3CP%3EFor%20sheet%201%2C%20columns%20C%20and%20D%20are%20different%20names.%20Column%20C%20is%20a%20company%20name%20whereas%20column%20D%20is%20a%20name%20of%20a%20person%20responsible%20for%20the%20engagement%20with%20that%20company.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20sheet%202%2C%20column%20B%20is%20the%20same%20company%20name%20as%20sheet1%20column%20C.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-790732%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793203%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlink%20Copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382367%22%20target%3D%22_blank%22%3E%40nlw47%3C%2FA%3EYou%20could%20use%20a%20formula%20like%20this%20one%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DHYPERLINK(%22%23'Sheet2'!A%22%26amp%3BMATCH(C2%2CSheet2!B%3AB%2C0)%2C%22Click%20to%20go%20to%20supplier%20%22%26amp%3BC2)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
nlw47
New Contributor

I am having trouble copy/pasting hyperlinks. For example, in the mock worksheet attached, I have supplier names listed in column C of sheet 1. In the real file, I have thousands of these supplier names in which I want to create hyperlinks that route to sheet2 column B. My issue is that when I try to copy a hyperlink- say C3 from sheet1 down to C4, the friendly name on C4 changes to the friendly name of C3. When pasting, I need each supplier name to remain their name and not transfer to another supplier name. My goal is that I need to be able to click and drag the hyperlinks on the supplier name column all the way down while the supplier names maintain their names. 

I am willing to try a macro (although not my preference bc I have little to no knowledge of macros). 

To clarify:

For sheet 1, columns C and D are different names. Column C is a company name whereas column D is a name of a person responsible for the engagement with that company. 

 

On sheet 2, column B is the same company name as sheet1 column C. 

1 Reply

@nlw47 You could use a formula like this one:

=HYPERLINK("#'Sheet2'!A"&MATCH(C2,Sheet2!B:B,0),"Click to go to supplier "&C2)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies