EXCEL - PDF/Print Generator, Auto remove 'blank' cells, Lock sheet, create template.
- or -
Post a project like this2536
$$
- Posted:
- Proposals: 15
- Remote
- #1547173
- Awarded
Description
Experience Level: Intermediate
General information for the business: Costs & Quotation Document
Description of excel work: Please provide reasonable quotations to complete the following tasks:
1. Create template document with only some editable cells (using existing sheet)
- See attached; Grey boxes have selections or input, these needs to be able to be edited each time a new costs form is created.
2. Lock all other cells so staff can not change figures/calculations etc.
- Red 'Quotation Price' cells need to be able to edit the figure and for it to override any other generated figures.
3. Create an automated print/PDF button for easy printing
4. When creating a PDF using the above button I need the sheet to automatically remove rows where the figure in cells 'F' is blank "-"
5. Additional:
- All figures in the Red 'Quotation Price' row need to be rounded up to nearest 5/0.
- If a group is collapsed it should not appear on the PDF/Print document.
Extra notes:
Description of excel work: Please provide reasonable quotations to complete the following tasks:
1. Create template document with only some editable cells (using existing sheet)
- See attached; Grey boxes have selections or input, these needs to be able to be edited each time a new costs form is created.
2. Lock all other cells so staff can not change figures/calculations etc.
- Red 'Quotation Price' cells need to be able to edit the figure and for it to override any other generated figures.
3. Create an automated print/PDF button for easy printing
4. When creating a PDF using the above button I need the sheet to automatically remove rows where the figure in cells 'F' is blank "-"
5. Additional:
- All figures in the Red 'Quotation Price' row need to be rounded up to nearest 5/0.
- If a group is collapsed it should not appear on the PDF/Print document.
Extra notes:
Richard L.
100% (17)Projects Completed
22
Freelancers worked with
20
Projects awarded
25%
Last project
17 Jun 2020
Viet Nam
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Richard, Still you are seeking someone?
400252
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