ExploreSunil
New Member
- Joined
- Dec 16, 2011
- Messages
- 5
Hello Masters , am new to this forum & ExcelIsfun mike has recommanded to check here for my query.
Hope i will get guidance here , Thanks in Advance
Say , I had 101 sheets. so for easy navigating through workbook i named a sheet as INdexSheet( where have placed a table with A , B Cols, A is sheetname , B is Hyperlink created to go for sheet )
Now has a drop down , where i can select a name from the list created out of A column.
The next cell should return B column( hyperlink) , It worked as mentioned.
But literally able to get B colum data not Hyperlink
Hope i will get guidance here , Thanks in Advance
Say , I had 101 sheets. so for easy navigating through workbook i named a sheet as INdexSheet( where have placed a table with A , B Cols, A is sheetname , B is Hyperlink created to go for sheet )
Now has a drop down , where i can select a name from the list created out of A column.
The next cell should return B column( hyperlink) , It worked as mentioned.
But literally able to get B colum data not Hyperlink
