Aug 06 2019 11:44 AM
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.
Aug 07 2019 07:36 AM
@nlw47 You could use a formula like this one:
=HYPERLINK("#'Sheet2'!A"&MATCH(C2,Sheet2!B:B,0),"Click to go to supplier "&C2)