• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. H

    Data Validation Using Multiple Named Columns

    I've solved the problem by making a hidden pivot table with a visible slicer. This allows the user to choose the Contractor name without duplicates and allows for a drop-down list that shows the correct Job Names associated with the chosen Contractor. Thanks for everyone's help!
  2. H

    Data Validation Using Multiple Named Columns

    Sajan, Again, this does not do what I need. Using the same data as in your example, I'd want to select "Area A" on the first dashboard selection cell, then have it populate all the dates associated with "Area A" in the second dashboard selection cell. I appreciate your help!
  3. H

    Data Validation Using Multiple Named Columns

    I have researched and looked through as many posts as I can think of to solve the problem before I resorted to posting a question on the forums. The link you suggested works great IF you have regularly defined items that are in discreet columns. Since the information I want to pull is all in...
  4. H

    Data Validation Using Multiple Named Columns

    I am building a workbook for tracking jobs. The first column is the contractor name. There are a standardized list of these, but sometimes they add a one-off name to this list. The next column is the job name (see example data below). Each job name will be unique. All the data is entered into a...
Back
Top