How to give links to a range of cells using data from another table?

K

Kevin Kostner2017-01-12 07:38:08

Visual Basic

Kevin Kostner, 2017-01-12 07:38:08

The situation is this: there is a column with file names AAAAA.jpg, BBBBB.jpg, etc. ... There is also a table in which there is a link to the right of the row name ... You need to assign the link www.111.com to the entire AAAAA.jpg range ... Tell me how this can be done, with a macro or script

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

K

Kevin Kostner, 2017-01-12
@zeroeight88

the result should be this

A

Anton Kiselyov, 2017-01-12
@zamboga

=HYPERLINK(B1,A1) insert in column "C" and drag the formula.
If it’s important for you in column A, then swap the columns.