Multiple Hyperlinks

[arjunw]

hi all,
I am trying to make an inventory management report on excel and i need some help.
I have a worksheet(master list) on which i need to create hyperlinks of some numbers i have put there(column A).These nos are my article codes.
The target link which has to be opened up is in a different file altogether in which every article has a separate worksheet.The names of these worksheets are the same article codes which iam using on my master list.
As there are around 1800 articles on my master list making each link one-by-one will be a very tedious exercise.Is there any way of doing this in one go with a MACRO??Can anyone help me out?
It would really sort out my work and be of great help.And please give step by step instructions as iam not very familiar visual basic.
Thank you!!

 

[Ralajer]

Welcome to the board arjunw,

If all the sheets are in the same Excel workbook then the HYPERLINK function could be used as shown below. No need for a macro.

Sheet Name/Article Numbers in Column A.
Place this formula in B2 or First Free Column Row 2.
=HYPERLINK("[C:\Folder\Articles.xls]'"&A2&"'!$A$1",A2)

Change C:\Folder\Articles.xls to match your path.​

Copy/Fill Down.
​

This will create Hyperlinks to the each sheet.