HYPERLINK Help - Mass Paste/Flashfill Hyperlink

Hi All,

See attached with questions/examples listed in Green and Yellow.....

I have a question/come to you for help regarding Hyperlinks.

Need to hyperlink hundreds of cells in a column whether it be via hyperlink text or a button assigned a hyperlink - whichever works.

The problem is that right-clicking, assigning the link to respected cell for each will likely take days haha..

Can a HYPERLINK Function accomplish this and allow me to flash fill the cells below?

Completley drawing a blank. I've been trying to figure it out for hours now and resorted back to the forum haha.

Thank you in advance for any assistance on this - Greatly appreciated.

Take care,

Tyler

Hi

Just enter these formulas in cells [N8], [O8], [P8] and copy the formulas down..

N8=HYPERLINK("#Sheet1!AB"&ROW(),"NOTE")
O8=HYPERLINK("#Sheet1!T"&ROW(),"CONTACT")
P8=HYPERLINK("#Sheet1!AF"&ROW(),"PAST MEETINGS")

NOTE: change Sheet1 in these formulas to the actual tabname for your particular sheet!

zeddy
Excel Hyperthinking Team

I love this Forum.

I appreciate the help. This worked perfectly.

You're awesome, Thank you!