[RESOLVED] Macro to create Hyperlink basing from cell address value

[leebrooke]

Hi,

I've looked in most threads related to creating macro for hyperlinks but i couldn't find one that can answer to my queries. Below is my problem.

I have two sheets, 1st sheet is a calendar, which contains Months and days. the 2nd sheet is only having 1 column with "Locate Date" as heading. Each of the rows within that column has values like L16, B25, B19, D9, D4, E10 etc.

i want to create a macro that will go through each of these values, and will create hyperlink with respect to sheet 1. For example, if in Sheet 2, cell1 has L16 value, then i want to make a hyperlink on cell1 which reference it's value to that in Sheet 1. Thus, when hyperlink is made, when i click on cell 1, it will go to Sheet 1 with address L16.

The original spreadsheet i have has hundreds of values in "Locate Date" column. It would take time for me to manually create a hyperlink in Excel if i have to do it one by one.

Please help me with this. I'd really appreciate your help. Attached is my sample workbook.