Excel Spreadsheet Programming/Automation
- or -
Post a project like this3494
$$
- Posted:
- Proposals: 13
- Remote
- #568520
- Awarded
Very experienced Excel user (including VBA), data analyst, and report writer. Currently working in a full time position but available on evenings and weekends.
Llanelli
Web designer, Brand designs including Flyers, business cards and other marketing materials
City of London
114612354955066696475328852424281443720510090649865665266739889757786
Description
Experience Level: Intermediate
General information for the business: I have an excel spreadsheet I need amendments to.
Industry: Business
Description of excel work: I have an excel spreadsheet developed. Currently people input their purchase orders on it. This then does two things 1. creates a PDF of the Purchase Order and automatically sends it to 2 email addresses. 2. Backs up all the information to a spreadsheet that we can then analyse. I need some amendments to this as follows 1. At the moment the VAT is automatically calculated at 20%, I still want it to default to 20% but would like the user to be able to amend this to either "included" (it will then take 20% off the total and move it to VAT) "no Vat" or a %age and it will calculate for them 2. I would like the user to input their email address and they will receive a copy of the PO. 3. If possible I would like the PO system to look different (different colours/fonts etc) I will supply details, although the changes to the look are non essential.
Extra notes:
Industry: Business
Description of excel work: I have an excel spreadsheet developed. Currently people input their purchase orders on it. This then does two things 1. creates a PDF of the Purchase Order and automatically sends it to 2 email addresses. 2. Backs up all the information to a spreadsheet that we can then analyse. I need some amendments to this as follows 1. At the moment the VAT is automatically calculated at 20%, I still want it to default to 20% but would like the user to be able to amend this to either "included" (it will then take 20% off the total and move it to VAT) "no Vat" or a %age and it will calculate for them 2. I would like the user to input their email address and they will receive a copy of the PO. 3. If possible I would like the PO system to look different (different colours/fonts etc) I will supply details, although the changes to the look are non essential.
Extra notes:
Lynne R.
100% (1)Projects Completed
3
Freelancers worked with
3
Projects awarded
80%
Last project
26 Aug 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