#1
|
|||
|
|||
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 Last edited by tarunbaweja; 03-20-2016 at 01:20 AM. Reason: add attachement |
#2
|
|||
|
|||
Perhaps you could us double click, something along the lines of this
Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Intersect(Target, Range("A2:A1000")) Is Nothing Then If Target.Value <> "" Then Cancel = True With Sheet2 .Select .UsedRange.AutoFilter Field:=6, Criteria1:=Target.Value End With End If End If End Sub |
Tags |
filter, hyperlink |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can a Data Source be one sheet in a multi-sheet Workbook | nfotx | Mail Merge | 1 | 07-01-2015 12:55 AM |
data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
How to add attached excel workbook with hyperlink in the same workbook | lynchbro | Excel Programming | 0 | 02-24-2015 01:29 PM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |