User Profile
robustexcel
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Data Validation cascading
i really apologize guys. It still gives me an error. This my excel version (image attached) fname =_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER(Employee[Fname], Employee[Lname]=LName.selected, Employee[Fname]))) lname =_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER(Employee[Lname], Employee[Fname]=FName.selected, Employee[Lname]))) select fname =_xlfn.ANCHORARRAY($H$3) select lnname =_xlfn.ANCHORARRAY($D$2)2.3KViews0likes2CommentsData Validation cascading
I have a form to fill in excel with two columns First Name and Last Name. Both are validation lists and the last name should be dependent on the value of the first name. I have a total of 400 names. See below as an example: Hidden worksheet with ONLY two columns: FName LName John Doe Kevin Hart Kevin Kinsley Rob Howard John Rambo Visible sheet for the user First Name: User to select Dropdown List available: John Kevin Rob Last Name: User to select based on the first name Eg. If the user selects John, the dropdown list should be Doe Rambo Similarly for Kevin and Rob. I hope this is clear 🙂 Thank YouSolved2.5KViews0likes6Comments
Recent Blog Articles
No content to show