Thread: [Solved] Hyperlink to open another sheet in same workbook with filtered data
View Single Post
 
Old 03-20-2016, 12:58 AM
tarunbaweja tarunbaweja is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Mar 2016
Posts: 1
tarunbaweja is on a distinguished road
Default Hyperlink to open another sheet in same workbook with filtered data
Hyperlink to open another sheet in same workbook with filtered data

I almost ended up looking after solution to my problem but could not find the same . I have data in one main top sheet . I want to create hyperlink on sheet 1 suppose Cell A2 that on clicking it goes to second sheet in same workbook and filters data in column F with criteria = value of cell A2 . Also want to create same hyper link for the entire sheet 1 range cells A2:A1000 . Searched could not find any solution , Thanks in advance
Attached Files
File Type: xls book1.xls (87.5 KB, 11 views)
Last edited by tarunbaweja; 03-20-2016 at 01:20 AM. Reason: add attachement
Reply With Quote