Results 1 to 6 of 6

how to filter a sheet based on a click value of column other sheet in excel

Threaded View

  1. 10-25-2018, 10:30 AM #1
    raja616
    raja616 is offline
    Registered User
    Join Date
    06-20-2017
    Location
    bangalore
    MS-Off Ver
    mac 2011
    Posts
    11

    how to filter a sheet based on a click value of column other sheet in excel

    Hi All~,
    I have two sheets in my workbook. One is "Invoices overview" and second one is "Invoices payments details".
    My requirement is if I click on Invoice number, it has to take me to invoice payments detail sheet and display record for that invoice only ( Basically set a filter with click cell value).

    Help will be appreciated.

    Thanks,
    Raja
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filter column on sheet based on List value
    By Maike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2018, 06:05 PM
  2. Want to Filter column data on Sheet 2 based on matching drop down selection on Sheet 1
    By jgaler in forum Excel General
    Replies: 2
    Last Post: 05-31-2016, 01:55 PM
  3. Populate Excel Userform with Sheet names with double click to open the sheet ??
    By Shacker in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-08-2013, 03:54 PM
  4. How to filter data based on a column criteria in another sheet
    By orangejulius in forum Excel General
    Replies: 2
    Last Post: 02-14-2013, 11:06 PM
  5. [SOLVED] Need: filter, paste info to new sheet, rename sheet, unfilter, hide column, filter next
    By esmithqg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2012, 04:49 PM
  6. My video - Click a cell to filter a sheet
    By bobby321 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2012, 01:27 AM
  7. Macro to filter based on column heading then copy and paste to new sheet
    By macattackr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2012, 05:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1