![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Excel Expert to make some modification in excel invoice
- or -
Post a project like this3555
$$
- Posted:
- Proposals: 3
- Remote
- #586557
- Awarded
Description
Experience Level: Intermediate
General information for the website: Excel invoice
Description of requirements/features: Hi there,
I have an excel invoice and I want to add some advance features.
I need to use green invoice design:
I want something attached with this message: shot2.jpg
For customer address, there will be drop down menu where admin selects the customer details and name, address, email and phone populates. If customer don’t have email or phone or address, those fields empty.
Then in body section, admin just selects the item code with the item name and then price unity price populates, admin enter the quantity manually.
Total section is automatic. On the same page I need print PDF button; on click it opens up print dialogue box and admin use PDF printer to print it. I already have PDF print which I will use. The important thing sometime it exceeds to 2 pages and there is too much white space on right side or bottom which should be fixed before sent to print.
Briefly, I need following features on main invoice.
Print button.
Discount calculation
There will 3 sheets:
1) Customer (data of all the customers) reference.xls is for reference
2) Items (details of all the items) reference.xls is for reference
3) Settings (configuration of invoice)
Customer table:
The same style which i have in reference.xls file.
Item table:
The same style which i have in reference.xls file.
On settings page:
Number of rows.
Line with description or without description.
Currency.
Adjust paper UK or US
I use excel 2003, maximum
Any question please ask.
Extra notes:
Description of requirements/features: Hi there,
I have an excel invoice and I want to add some advance features.
I need to use green invoice design:
I want something attached with this message: shot2.jpg
For customer address, there will be drop down menu where admin selects the customer details and name, address, email and phone populates. If customer don’t have email or phone or address, those fields empty.
Then in body section, admin just selects the item code with the item name and then price unity price populates, admin enter the quantity manually.
Total section is automatic. On the same page I need print PDF button; on click it opens up print dialogue box and admin use PDF printer to print it. I already have PDF print which I will use. The important thing sometime it exceeds to 2 pages and there is too much white space on right side or bottom which should be fixed before sent to print.
Briefly, I need following features on main invoice.
Print button.
Discount calculation
There will 3 sheets:
1) Customer (data of all the customers) reference.xls is for reference
2) Items (details of all the items) reference.xls is for reference
3) Settings (configuration of invoice)
Customer table:
The same style which i have in reference.xls file.
Item table:
The same style which i have in reference.xls file.
On settings page:
Number of rows.
Line with description or without description.
Currency.
Adjust paper UK or US
I use excel 2003, maximum
Any question please ask.
Extra notes:
![Haroon R.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/e177158e961c4a39f580fdae66218cf8_150x150.jpg)
Haroon R.
97% (19)Projects Completed
25
Freelancers worked with
19
Projects awarded
34%
Last project
29 Mar 2019
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