I have a file excel with school's and student name. I wish to use drop list to facilitate business input data in leader page. School's name and student name in a others worksheet. If in my drop list I choose column SCHOOL name Chelsea High School and in column STUDENTNAME, I want only RONALDO, PATRICK ADAM and LUCY name display for me to making choice.
Last edited by redza; 10-22-2012 at 05:39 AM. Reason: COMPLETED
Check this links for step by step instruction.
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal13.html
---
Sixthsense
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I have modified your data a bit, and added/changed some of your named ranges.
see if this is what you wanted?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank youSixthsense
glad to help. as a new member, you may not be aware that you can thank those who helped you by clicking on the star at the bottom left of your post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks