EXCEL/VBA Project
- or -
Post a project like this3329
$10
- Posted:
- Proposals: 5
- Remote
- #685940
- Awarded
Description
Experience Level: Entry
General information for the business: Personal Project
Kind of development: Customization of existing program
Description of requirements/functionality: 98 percent of the file is done. I just wanted you to be able to produce the university ranking results when a user selects just the country. First of all, there are `3` agencies that use rankings. These include, QS, THE, and SHANGHAI (or ARW). As of right now, I have the macros written for the user selecting a university and the country corresponding to the university already sets as default so they don`t have to think about where the university is located. Then the user would choose faculty of engineering or all in the second combo box. After when they click search all the ranking results would output in the output window. This way you can make up 16 searches until you can clear it away.What I want you to do for me is what if the user only selects a country and the faculty. All the universities and rankings in that country should be outputted in the table. In this case some countries might have more than 16 universities in which the output table is only capable of holding that much. So when there are more than 16 universities the table should automatically get bigger to fit all the universities. But when the user clicks the rest button in the output window, then it should go back to the normal table size. So if a user selects a country and chooses `ALL` as the faculty, then there are sheets in the workbook called QS world, THE world, SHANGHAI world. It should look for universities only in these sheet names and coutput the university name and their rank in way the output table has been designed. But if you select a country and `FACULTY OF ENGINEERING` as the faculty, then it should look into QS ENG, THE ENG, and SHANGHAI Eng and output the ranking results according to the output table. You can see how it works by choosing the university name, faculty and clicking search (this is the macros that I have already written). Again, 98% of the file is already done. This is not much work at all so please be easy with this.
Thanks
Extra notes:
Kind of development: Customization of existing program
Description of requirements/functionality: 98 percent of the file is done. I just wanted you to be able to produce the university ranking results when a user selects just the country. First of all, there are `3` agencies that use rankings. These include, QS, THE, and SHANGHAI (or ARW). As of right now, I have the macros written for the user selecting a university and the country corresponding to the university already sets as default so they don`t have to think about where the university is located. Then the user would choose faculty of engineering or all in the second combo box. After when they click search all the ranking results would output in the output window. This way you can make up 16 searches until you can clear it away.What I want you to do for me is what if the user only selects a country and the faculty. All the universities and rankings in that country should be outputted in the table. In this case some countries might have more than 16 universities in which the output table is only capable of holding that much. So when there are more than 16 universities the table should automatically get bigger to fit all the universities. But when the user clicks the rest button in the output window, then it should go back to the normal table size. So if a user selects a country and chooses `ALL` as the faculty, then there are sheets in the workbook called QS world, THE world, SHANGHAI world. It should look for universities only in these sheet names and coutput the university name and their rank in way the output table has been designed. But if you select a country and `FACULTY OF ENGINEERING` as the faculty, then it should look into QS ENG, THE ENG, and SHANGHAI Eng and output the ranking results according to the output table. You can see how it works by choosing the university name, faculty and clicking search (this is the macros that I have already written). Again, 98% of the file is already done. This is not much work at all so please be easy with this.
Thanks
Extra notes:
Kushal G.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
19 Jun 2015
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies