Results 1 to 20 of 24

Thread: How to enable data to be filtered based of values in Data valuation cells

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-09-2024, 04:59 AM #1
    Aussiebear
    Aussiebear is offline
    Site Admin VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,496
    Location

    How to enable data to be filtered based of values in Data valuation cells

    In the attached workbook, I am looking for a method to assist in making a decision on treatment option for bee colonies.

    Part 1: On Sheet 1, there 4 basic Questions in cells B2, B4, B6 & B8, with respective Answers to be provided in cells C2, C4, C6 & C8. I am requiring a automated response in cell E4 based on being able to use the answers to Questions 1 & 2 by looking up the value in the TblCount on Sheet 2.

    Part 2: Also on Sheet 1, I would like the option of displaying (triggered by cell E4 value is "Treat") the various Chemical Products (from TblProducts) somewhere on Sheet 1, providing it meets the conditions determined by Questions 2, 3 & 4.

    Is this possible?
    Attached Files Attached Files
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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