Consulting

Results 1 to 3 of 3

Thread: Rows to hide and unhide based on two columns

  1. #1

    Rows to hide and unhide based on two columns

    Hi All

    I have created a workflow for which i am facing a issue, the ask is i have column B8 having data input values and column B9 also has data values stored, so for example when B8 is selected with toys B9 column is visible and user has to input data such as car so when toys and car are selected row 12 should be hidden and row 13 should be unhidden, like vise B8 has car as value in it where in there are another set of rows are hidden and unhidden, will you please help me to hide and unhide when there are two values selected in two columns, i tried using and but it did not work.


    Please help

  2. #2
    VBAX Mentor
    Joined
    Nov 2020
    Location
    Cochin, Kerala
    Posts
    314
    Location
    Attach a sample file

  3. #3
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    column B8 having data input values and column B9 also has data values stored, so for example when B8 is selected with toys B9 column is visible
    Cells B8 & B9 are both in the same column (B) and that column can not be both hidden and visible at the same time.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

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