+ Reply to Thread
Results 1 to 2 of 2

Filter data in sheet 2 based on cell value in 1

  1. #1
    Registered User
    Join Date
    06-13-2017
    Location
    essex, england
    MS-Off Ver
    2013
    Posts
    11

    Filter data in sheet 2 based on cell value in 1

    I want to click a cell and from there go to another page based on a cell value from the first.

    So far I have
    -----------------
    Open explicit

    Private sub Worksheet_Selectionchange(ByVal Target as Range)

    If selection.count = 1 Then
    If Not intersect(Target, Range("D7")) is Nothing Then

    Sheets("Data").Select

    Active sheet.Range("$A$1:$BH$1000").AutoFilter Field:=52, Criteria1:=("Details") & Range("B7")

    End if
    End if

    End sub


    This selects the second worksheet and shows the heading but is not showing the data from the required cell.

    Any help would be appreciated

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Filter data in sheet 2 based on cell value in 1

    Try this
    Please Login or Register  to view this content.
    And not "Open explicit", but "Option Explicit" ... : ) ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 05-31-2016, 01:55 PM
  2. Excel VBA - Copy Data based on a cell value and filter to new sheet
    By scruz9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2016, 08:06 AM
  3. Filter data on a sheet based on a drop down from another sheet
    By SR46 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2015, 07:57 PM
  4. To filter data based on a particular value in other sheet
    By sasankmohan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-22-2014, 11:14 AM
  5. Replies: 1
    Last Post: 08-06-2013, 02:47 AM
  6. Move data from Sheet 1 to Sheet 2 based on critera like adv filter?
    By gspivey79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 12:45 PM
  7. Fetch data from another sheet based on a filter value
    By jrule in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2011, 12:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1