Hyperlink to open another sheet in same workbook with filtered data

tarunbaweja · #1 03-20-2016, 12:58 AM

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

NoSparks · #2 03-20-2016, 06:52 AM

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

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