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!
Please ignore the first attachment, it did not contain all of the correct information.
21 freelancer bu iş için ortalamada 31$ teklif veriyor
Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Daha fazlası
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.
after scanning the code vba, i can identify the problem that in code the state Rrng = [url removed, login to view]([url removed, login to view](2, c), [url removed, login to view](lr, c)) use the c variable to identify the column of the target data. However, the match fun Daha fazlası