+ Reply to Thread
Results 1 to 1 of 1

Dynamic validation with list that have been auto filtered

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Dynamic validation with list that have been auto filtered


    I hope you can help

    The attached workbook has, in effect, two different tables on the sheet

    Table A has a list of both lecturers and students in the same list. The list can be auto-filtered to give either the list of lecturers or the list of students.

    class occurrence
    lecturer lecturer1
    lecturer lecturer2
    lecturer lecturer3
    student student1
    student student2
    lecturer lecturer9
    lecturer lecturer10
    lecturer lecturer11

    Table B shows which lecturer has been allocated to which student.

    lecturer student

    lecturer1 student2
    lecturer2 student2
    lecturer3 student1

    At the moment, the lecturer and student cells have data validation set to look at fixed ranges of lecturers and students in table A

    The problem is that the static defined list only includes the first three lecturers. I have added three new lecturers after the student entries. What I need is for the data validation in table B to change from static ranges to a dynamic AUTOFILERED ranges. (i.e. not a consecutive set of rows).

    Is this possible?

    Thanks. Any help would be very much appreciated
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


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