0

I have a Column of data in excel with employee names, I am trying to hyper link each cell to the Employee file in a directory, the names for the folders and cells are formatted identically. I could manually go through and hyperlink these however that would be very tedious and I am hoping there is a function that can accomplish this that I am not familiar with.

I think this is also doable using macros/vba however that is something I have not used in the past.

Thanks for your time and feedback!

Axios_Andrew
  • 63
  • 1
  • 2
  • 7
  • Dear @Axios_Andrew: did I solve your problem? If yes, please "accept" my answer by clicking the check symbol next to it. Thank you. – nicolaus-hee Jun 01 '15 at 12:09

1 Answers1

0

Use the =HYPERLINK function in column B. Assuming that the files are in C:\directory\ and that they are called "content in column A".xlsx -- try this:

=HYPERLINK("C:\directory\"&A1&".xlsx", A1)

Source: Microsoft: HYPERLINK function

nicolaus-hee
  • 787
  • 1
  • 9
  • 25