Hey there--

So I have a main spreadsheet with names that pull data from 400 individual worksheets that are named numerically. Is there an easy way to macro hyperlinks? This is so when other users view the main spreadsheet they can click on the name and open up the individual sheet.

Example: in the B column, starting with B3, I have Jon Smith, who is linked to http://intranet/server/card 1.xls, then in B4 I have Jane Doe who is linked to http://intranet/server/card 2.xls, and so on and so forth all the way till "card 400.xls"

Thanks in advance for anyone's help!