macro to hyperlink

Topic

New Reply

I have an excel file with a list 40,000+ files. The spreadsheet includes the full path for each file (see column C, attached file for the first few rows).
What’s the quickest way to hyperlink the files? If it’s a macro, anyone have a copy I could use?

Thanks.

Reply | Quote

Replies

Hi

The quickest way is probably to add a formula in a spare column, say [N]:
In cell [N2], enter this formula:
=HYPERLINK(C20)
..then, to quickly copy this formula down to the end of the block of 40,000 rows, put the cellpointer in cell [N2] and double-click the small black square in the bottom-right corner (the cursor will ‘change’ to a + when you hover over the little black square)

zeddy

Reply | Quote

Thank you.
I figured there had to be an easy way………..

Reply | Quote