Transform an excel database into a dynamic price list for printing
- or -
Post a project like this2356
$$$
- Posted:
- Proposals: 8
- Remote
- #1770832
- Awarded
Customer Support, Bookkeeping, Data entry, Product listing, Virtual assitant
Coimbatore
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
1160793545010122805013341031406416144947317107211852123
Description
Experience Level: Expert
I have an excel spreadsheet that consists of 106 sheets Each sheet is exactly the same and contains pricing data derived from formulas to give a product selling price for quantity breaks and other options. Also there is information on shipping costs and weights etc.
The task is to write something that pulls the necessary information from each sheet and display it in single multi page price list format for our distributors to work from.
Since prices etc do change month to month it will be necessary to easily update the price list from the original excel file and add new lines as they are added to the product pricing list. This all could be done by cutting and pasting but it would be laborious and prone to errors. I think something like a look up table would do it
The task is to write something that pulls the necessary information from each sheet and display it in single multi page price list format for our distributors to work from.
Since prices etc do change month to month it will be necessary to easily update the price list from the original excel file and add new lines as they are added to the product pricing list. This all could be done by cutting and pasting but it would be laborious and prone to errors. I think something like a look up table would do it
Andy K.
100% (1)Projects Completed
8
Freelancers worked with
9
Projects awarded
64%
Last project
17 Oct 2016
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