Enhancement of xls RoI calculator with VBA
- or -
Post a project like this£100(approx. $126)
- Posted:
- Proposals: 1
- Remote
- #3901
- Expired
Description
Experience Level: Intermediate
The project entails the enhancement of a .xls file as follows:
1. Use of macros (VBA) for two things:
a. to show / hide the relevant cells if the input is Y / N, e.g in worksheet called %u2018Initial #%u2019s%u2019 if a user chooses %u2018N%u2019 in cell D12 then cells E12 and F12 should not appear and F12 should take value of zero.
b. to disregard relevant data if a %u2018NO%u2019 is selected, e.g. if user chooses NO>> in worksheet %u20182nd semester%u2019 (cell E14) then values in worksheet %u20182nd semester_1%u2019 should be disregarded (taking zero value) in calculations.
2. Not allowing users to jump from one worksheet to another by clicking on the tabs below, but only by following the relevant Next / Back buttons and always start file with the worksheet called %u2018Start%u2019
3. Validating the cells on those that require user input %u2013 while this has been done already for most of the cells, those that require input of as %%u2019s still require validation, e.g. cells D6 and E6 in worksheet called %u20181st semester%u2019
Notes:
1. The individual worksheets and the file are password protected.
2. The worksheet with the calculations has been hidden. This should not require any modifications.
3. For any questions about the scope of the project and/or to get the password to unlock the worksheets please email me
1. Use of macros (VBA) for two things:
a. to show / hide the relevant cells if the input is Y / N, e.g in worksheet called %u2018Initial #%u2019s%u2019 if a user chooses %u2018N%u2019 in cell D12 then cells E12 and F12 should not appear and F12 should take value of zero.
b. to disregard relevant data if a %u2018NO%u2019 is selected, e.g. if user chooses NO>> in worksheet %u20182nd semester%u2019 (cell E14) then values in worksheet %u20182nd semester_1%u2019 should be disregarded (taking zero value) in calculations.
2. Not allowing users to jump from one worksheet to another by clicking on the tabs below, but only by following the relevant Next / Back buttons and always start file with the worksheet called %u2018Start%u2019
3. Validating the cells on those that require user input %u2013 while this has been done already for most of the cells, those that require input of as %%u2019s still require validation, e.g. cells D6 and E6 in worksheet called %u20181st semester%u2019
Notes:
1. The individual worksheets and the file are password protected.
2. The worksheet with the calculations has been hidden. This should not require any modifications.
3. For any questions about the scope of the project and/or to get the password to unlock the worksheets please email me
Rachel C.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
75%
Last project
4 May 2011
United Kingdom
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