VBA Programming, Excel Spreadsheet Application Design
- or -
Post a project like this3635
£30/hr(approx. $38/hr)
- Posted:
- Proposals: 2
- Remote
- #468347
- Awarded
Description
Experience Level: Expert
Estimated project duration: less than 1 week
General information for the business: Excel Spreadsheet Development
Description of requirements/functionality: I'm looking for some help in completing a spreadsheet VBA project for a routine monitoring program in Excel 2013. The workbook is to be self-contained per user, will be saved away each month and will contain all the data for one year.
Following setup detailing start month, frequency of tests and number of test points - I need to build a dynamic monthly data entry form showing tests that need completion on that month, along with conditional formatting of cells dependent on data entered.
For some tests I need to dynamically show other worksheets for completion, the number required depending on the number of test points, which is variable on setup.
A work in progress spreadsheet is attached here, with further details and instructions. Many of the basic worksheets have been produced but automation of the correct number of them has still to be done. I am happy to discuss it further with you if you think you can help me so that you can understand the job and estimate how long it will take. I am happy to take advice on how the result can be best achieved.
I anticipate this may take several hours, perhaps a day or more. I would need some availability in the coming week as I need to show that this can be achieved and that progress is being made, say by Weds/Thurs.
Please detail previous relevant experience, contact details, availability, and give some examples of work if possible.
Specific technologies required: Microsoft Excel 2013, VBA
Extra notes:
Description of requirements/functionality: I'm looking for some help in completing a spreadsheet VBA project for a routine monitoring program in Excel 2013. The workbook is to be self-contained per user, will be saved away each month and will contain all the data for one year.
Following setup detailing start month, frequency of tests and number of test points - I need to build a dynamic monthly data entry form showing tests that need completion on that month, along with conditional formatting of cells dependent on data entered.
For some tests I need to dynamically show other worksheets for completion, the number required depending on the number of test points, which is variable on setup.
A work in progress spreadsheet is attached here, with further details and instructions. Many of the basic worksheets have been produced but automation of the correct number of them has still to be done. I am happy to discuss it further with you if you think you can help me so that you can understand the job and estimate how long it will take. I am happy to take advice on how the result can be best achieved.
I anticipate this may take several hours, perhaps a day or more. I would need some availability in the coming week as I need to show that this can be achieved and that progress is being made, say by Weds/Thurs.
Please detail previous relevant experience, contact details, availability, and give some examples of work if possible.
Specific technologies required: Microsoft Excel 2013, VBA
Extra notes:
Joanne S.
100% (4)Projects Completed
6
Freelancers worked with
6
Projects awarded
25%
Last project
22 Oct 2015
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