I need assistance with a small Excel project that has already been worked on, but isn't pulling the correct information. It is an interactive dashboard that allows the user to select either a year, or a teachers name, and it gives information pertaining to that selection.
The file consists of 3 sheets:
DASHBOARD - where the user makes their selection
Sheet1 - where all the information is located
List - which contains a combined list of the first and last names, and the years.
If a Year is selected it shows the ID, Last Name, First Name, Degree, Year, and Job Title of every teacher that worked that year.
If a Name is selected it displays the ID, Last Name, First Name, Degree, Year, and Job Title of that particular teacher
Everything is completed, but I need assistance with an issue in the VBA programming. There are 2 bugs I have found. 1) If someone with the same last name is selected, it pulls the information from the first person in the list with the same last name.
For example, If I choose Patricia Maxcy Wilson, Sam Wilson, or Lloyd T Wilson, all 3 bring up the information for John M. Wilson. The name displays correctly, but the information under the year and job title is incorrect.
2) There is also an issue of last names with spaces not displaying. For example Atkinson Mo, Alonzo. When his name is selected, nothing happens.
Any assistance with this project would be greatly appreciated!
21 freelancer bu iş için ortalamada 31$ teklif veriyor
Hello, I'm not sure if you already have another freelancer working with you on this but I could lend a hand if you desire. I look forward to possibly lending a hand.