Manipulate excel file content to create customer invoice
- or -
Post a project like this3887
$$
- Posted:
- Proposals: 7
- Remote
- #307475
- Completed
Excel Expert, Excel Spreadsheets, Excel VBA & Access Database Developer, Data modelling & Analysis
London
49866990327146385451641494538504723510090
Description
Experience Level: Intermediate
Attached is a zip file containing 4 excel files and a png file. The first with the following worksheets: Summary Invoice Sheet, Graphical Sheet, Mobile Summaries 1/2…, Combined CDR and Invoice Required Data. The second, third and fourth are data files that need defined mobile numbers to be extracted combined and inserted into the first file in a worksheet "Combined CDR".
In this file example I have already, manually, combined the CDR's that are in the zip file and the "Combined CDR" worksheet. I have also entered example data into the Invoice Required Data worksheet (this will always be input manually).
I have put the rules for the sorting and filtering of data in the first worksheet.
To summarise, I envisage the excel file being run monthly on a per customer basis, that I insert the relevant customer data in the file and run the process by pressing a "button". This will populate the individual totals for each mobile number, summarise the totals on the invoice, produce graphs of usage and create PDF files from each worksheet so that we can send to customers.
Hopefully this is enough information for you to provide me with a quote and timescales.
In this file example I have already, manually, combined the CDR's that are in the zip file and the "Combined CDR" worksheet. I have also entered example data into the Invoice Required Data worksheet (this will always be input manually).
I have put the rules for the sorting and filtering of data in the first worksheet.
To summarise, I envisage the excel file being run monthly on a per customer basis, that I insert the relevant customer data in the file and run the process by pressing a "button". This will populate the individual totals for each mobile number, summarise the totals on the invoice, produce graphs of usage and create PDF files from each worksheet so that we can send to customers.
Hopefully this is enough information for you to provide me with a quote and timescales.
Sean L.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
10 Sep 2013
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