I'm doing Budget Update and the names are in street addresses.
I'm try to hyperlink from Sheet1 Column A to Sheet2 Column C that has the same name.
So when you double click on any cell in Sheet1 Column A, it will take you to the cell in Sheet2 Column C that has the same name.
The trouble is that in Sheet2 Column C, the names are in drop down list box and merged with five cells (C6:G6), (C25:G25), (C50:G50), etc.
Here's the code I've create but somehow, there must be a simple fix for 5 merged cells from Column C in Sheet2 like in
And this is the code
Here's the attachement for some idea
ExcelHyper.xls
Bookmarks