
Very quick VBA task
- or -
Post a project like this113
£15(approx. $20)
- Posted:
- Proposals: 1
- Remote
- #4304027
- Awarded
Description
Experience Level: Entry
Task 1 - Calculate the target values (Cells D4:D6)
In columns E, F and G, I want it to fill in calculated values in the range E24 to G28, but only the number of years specified in the cells in row 12.
So if they select in row E12 "2" then it will only calculate the values in cells E24 and E25.
Task 2 - create arrays to calculate the Assumed lower range and Assumed Worst Case
I don't want these displayed on the sheet but I do what the values calculated into the range (E4:F6)
In columns E, F and G, I want it to fill in calculated values in the range E24 to G28, but only the number of years specified in the cells in row 12.
So if they select in row E12 "2" then it will only calculate the values in cells E24 and E25.
Task 2 - create arrays to calculate the Assumed lower range and Assumed Worst Case
I don't want these displayed on the sheet but I do what the values calculated into the range (E4:F6)

Solomon D.
100% (95)Projects Completed
72
Freelancers worked with
68
Projects awarded
58%
Last project
10 Dec 2024
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