Excel FORMS WORKBOOK /VBA Coding
- or -
Post a project like this$150
- Posted:
- Proposals: 26
- Remote
- #2547896
- Expired
169487331269862744138274916829485962986424305992130901443230171323529732348512692833
Description
Experience Level: Entry
We do have a complex workbook. consisting of 12 sheets with questionnaire need to be answered.
- we request to create front end dynamic FORM end of each Section of the first sheet as independent form
- some sheets do have calculated fields that should be making some calculation based on related interlinked fields from various form accordingly
- dynamic FORMS
- create Function Sheet where the newly created FORMS for each section of the first sheet can be accessed as FORMS meaning we should have buttons accessing FORMS each FORM with check box to check once user complete the form as well with each form a VIEW/ HIDE BUTTON to view hide the backend excelsheet of the form that would be password protected.
- save DATA entered on the EXCEL sheet as a BACKEND DATA of each respective Section keeping the rules created on cells etc... and access that backend sheets via protected password
- SAVE THE DATE AS WELL ON THE FORMS ITSELF TOO for editing purposes
- Make the workbook faster by unlinking any sources.
- Create & Print & email a Report with ability to edit before generation to PDF. REPORT will consist of some generic information (fixed) we will provide and based on the FORMS Questions answered by users
-Generate Invoice & print & email an invoice ( we will provide a standard invoice format)
-Each workbook has a rate& rules sheet that based on specific criteria entered on the FORMS it chooses the specific rates and this sheet should be very very hidden not accessed through VBA only by unique password
- The FORMS Must be DYNAMICS. retain the DATA so users can edit them at the user discretion
- the workbook has to have LOGIN USERS With various security level such as certain fields are only available for Quality Control agents verifying the users work and generate a quality control report on each completed workbook.
project is urgent. we will only show the template via skype session. we would like to have the project completed 24-48 hours.
- we request to create front end dynamic FORM end of each Section of the first sheet as independent form
- some sheets do have calculated fields that should be making some calculation based on related interlinked fields from various form accordingly
- dynamic FORMS
- create Function Sheet where the newly created FORMS for each section of the first sheet can be accessed as FORMS meaning we should have buttons accessing FORMS each FORM with check box to check once user complete the form as well with each form a VIEW/ HIDE BUTTON to view hide the backend excelsheet of the form that would be password protected.
- save DATA entered on the EXCEL sheet as a BACKEND DATA of each respective Section keeping the rules created on cells etc... and access that backend sheets via protected password
- SAVE THE DATE AS WELL ON THE FORMS ITSELF TOO for editing purposes
- Make the workbook faster by unlinking any sources.
- Create & Print & email a Report with ability to edit before generation to PDF. REPORT will consist of some generic information (fixed) we will provide and based on the FORMS Questions answered by users
-Generate Invoice & print & email an invoice ( we will provide a standard invoice format)
-Each workbook has a rate& rules sheet that based on specific criteria entered on the FORMS it chooses the specific rates and this sheet should be very very hidden not accessed through VBA only by unique password
- The FORMS Must be DYNAMICS. retain the DATA so users can edit them at the user discretion
- the workbook has to have LOGIN USERS With various security level such as certain fields are only available for Quality Control agents verifying the users work and generate a quality control report on each completed workbook.
project is urgent. we will only show the template via skype session. we would like to have the project completed 24-48 hours.
Richard A.
100% (11)Projects Completed
11
Freelancers worked with
9
Projects awarded
44%
Last project
7 May 2020
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Richard,
Do you want me to bid on this project, or it is already awarded?
850394
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