Results 1 to 2 of 2

Thread: Data Validation

  1. #1

    Data Validation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I am new to this forum

    I would like to ask if you could help me with my problem. I am currently creating a progress monitoring report and I have data which looks like this:


    On sheet 1 Column A, let's say I have the name of my staff


    Staff Report
    AAA Report 1
    AVM Report 2
    AAA Report 3
    RGR Report 4
    AVM Report 5
    AVM Report 6





    On sheet 2, I have a dropdown cell for Staff and a dropdown cell for Report.


    What want to do is when, for example I chose Staff AAA, I will only see all the Reports of staff AAA to the Report Dropdown.

    Staff <Dropdown list>
    Report <Dropdown list>

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365

Posting Permissions

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