+ Reply to Thread
Results 1 to 2 of 2

Hyperlink a Cell to filter that cell value based on colour filters used in another sheet

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    3

    Hyperlink a Cell to filter that cell value based on colour filters used in another sheet

    Hi Guys,

    I would really appreciate if you could help me out here.

    I have a table which says that this is the amount of coloured cells we have in another sheet.

    For e.g.

    Field Name Code A
    Item Description 5

    Now, the item description column has 5 cells in another sheet which are filled in with "Yellow" Colour. So what i want to do is to click on this 5 in sheet 2 in this case as per the attached sample which takes me to the filtered result on sheet1 of 5 yellow coloured cells under the column of Item description including an additional filter of Code "A"

    Thanks and really appreciate your response..

    Best Regards,
    Spidy.
    Attached Files Attached Files

  2. #2
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: Hyperlink a Cell to filter that cell value based on colour filters used in another she

    In sheet 1 col d i have used a helper col. for filter criteria.
    and i have created a macro button.
    In sheet 2 b2 put the no of item as desired, and click the button and in a2 put thye iten to be displayed viz. "a" or "b" and click the button.
    The result will show no of items of the selected item.
    Plz see the attachment
    Attached Files Attached Files
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

+ 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. Change cell colour, based on matched cells in sheet 2
    By Bobbo Jones in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 02:27 AM
  2. 1. Sheet Range Tab colour changed based on Cell value referenced against 3 lists
    By james 35 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 07:20 AM
  3. Replies: 1
    Last Post: 03-11-2013, 03:10 PM
  4. Replies: 1
    Last Post: 03-10-2013, 01:54 PM
  5. Replies: 3
    Last Post: 07-15-2010, 08:49 AM

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