Devam Ediyor

Troubleshooting Excel / VBA Dashboard

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!

Beceriler: Excel, Uygulamalar için Visual Basic

Daha fazlasını görün: vba excel programming, sam dashboard, programming vba, programming excel vba, excel programming vba, degree programming, vba excel dashboard, interactive excel, excel selection list, vba file list excel, vba excel selection, user dashboard, vba sheets, small vba, small basic vba, applications excel, vba small, user information list excel, dashboard project vba excel, excel vba troubleshooting, small excel, troubleshooting vba excel, troubleshooting vba, project excel dashboard, excel project vba

İşveren Hakkında:
( 8 değerlendirme ) Deland, United States

Proje NO: #6536606

Seçilen:

Aldo21

Hi, Im excel expert. Please check some of my previous work: Budget planner https://www.dropbox.com/s/edubgxgaypsd9hp/BUDGET%20PROJECT.xlsm?dl=0 cost Spliter https://www.dropbox.com/s/sc321g7qhdlshgj/FORM_FINAL Daha fazlası

3 gün içinde 10$ USD
(12 Değerlendirme)
3.3

21 freelancer bu iş için ortalamada 31$ teklif veriyor

zExcel

A proposal has not yet been provided

in 0 gün içinde50$ USD
(107 Değerlendirme)
6.5
jaylancer43

Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Daha fazlası

in 0 gün içinde30$ USD
(77 Değerlendirme)
5.8
nagybatonyi

I checked the bugs you wrote but the first one (same last name is selected) did not show up in my Excel2010. Which version do you use? I see the cause of the second bug and I have a suggestion to fix it. I can complet Daha fazlası

1 gün içinde 25$ USD
(56 Değerlendirme)
5.7
chriskerpini

Hello, Your code is fixed and tested. I will explain you the reasons of these bugs and the fixes. A few words about me: I'm developing VBA programs for more than 15 years and I'm a VBA and Excel trainer for 12+ y Daha fazlası

in 0 gün içinde25$ USD
(35 Değerlendirme)
5.6
srinichal

Let me know more details about the issues and I can fix them as per your specifications and needs .

in 3 gün içinde54$ USD
(10 Değerlendirme)
5.1
expertatwork

Hello there - we can help you on this. Please reply. We can discuss further. thank you !!!

1 gün içinde 27$ USD
(70 Değerlendirme)
5.1
finecodervw

If you are online, we can have a quick chat on this and get this started. Waiting to hear back from you. Thanks ========== Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Daha fazlası

1 gün içinde 30$ USD
(30 Değerlendirme)
5.0
vikas0903

Hi, I have done similar project, for another client, for whom I accessed https://www.smarteda.qld.gov.au/pools/properties/propertySearch.action to get houses with swimming pool in Brisbane. It was completed successful Daha fazlası

1 gün içinde 30$ USD
(17 Değerlendirme)
4.8
microk

Expert here. Let's start discussion on this. Microk Extreme Excel Solutions http://www.extremeExcelSolutions.weebly.com

in 2 gün içinde30$ USD
(31 Değerlendirme)
4.5
tomislav1975

Check portfolio and contact me if interested. Thanks, Tom______________________________________________________

1 gün içinde 50$ USD
(12 Değerlendirme)
4.2
paris2785

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: 1.Real Estate (video demonstration) 2.Orders (video demonstrat Daha fazlası

in 5 gün içinde60$ USD
(23 Değerlendirme)
4.2
mkhrsunil

Hi, I understood your requirements and working on same to implements. kindly give me some time will be back after solution Thanks

1 gün içinde 20$ USD
(3 Değerlendirme)
3.6
kher78

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.

1 gün içinde 25$ USD
(11 Değerlendirme)
3.5
vsprybhanu

Hi, I've debugged your first bug. 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. I can solve 2nd bug shortly. Please s Daha fazlası

1 gün içinde 25$ USD
(7 Değerlendirme)
2.8
abhinovpankaj

Hi, I am working as software professional in IT industry from last 3 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio i Daha fazlası

1 gün içinde 28$ USD
(3 Değerlendirme)
2.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
upinipin2013

Hi i have read your project description. I am it guy skilled on excel formula and formatting. Please send details by pm Vest Regards

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
ashishseth1988

Hi, I am working as software professional in IT industry from last 3 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio i Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
gusainas

A proposal has not yet been provided

in 2 gün içinde20$ USD
(0 Değerlendirme)
0.0
kychenh

after scanning the code vba, i can identify the problem that in code the state Rrng = sws.Range(sws.Cells(2, c), sws.Cells(lr, c)) use the c variable to identify the column of the target data. However, the match fun Daha fazlası

in 3 gün içinde35$ USD
(0 Değerlendirme)
0.0