I need support creating a price list from a couple of system extracts using VBA
- or -
Post a project like this2332
$$
- Posted:
- Proposals: 8
- Remote
- #1821565
- Awarded
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
1371827365275122805013004491365006140641615261681957612
Description
Experience Level: Intermediate
General information for the business: Manufacturing
Description of excel work: I currently download three extracts from my finance system which provides all of the relevant detail I require however it isn't in the most useable format without significant manipulation. I want something writing where I can drop the relevant extracts into the file and run the macro to then update on an ongoing basis.
Effectively I'm looking for the following - all of which can be found in the attachment:
1. List Price Extract - shows base price for all products in the list
2. Pricing Report - takes this list price and then uses discounts to get to the end customer price. If no discounts are charged then the list price is charged.
3. Pricing Report for the next 30 Days - shows if I will be providing any other discounts over a certain timeframe.
Snippets of the extracts and the ideal output format are shown in the attachment. The reports need to capture all possible customer and product combinations and needs to be able to function as I continue to grow my product range and customers.
Design and target audience: Personal Use so format as per the attached Excel
Extra notes:
Description of excel work: I currently download three extracts from my finance system which provides all of the relevant detail I require however it isn't in the most useable format without significant manipulation. I want something writing where I can drop the relevant extracts into the file and run the macro to then update on an ongoing basis.
Effectively I'm looking for the following - all of which can be found in the attachment:
1. List Price Extract - shows base price for all products in the list
2. Pricing Report - takes this list price and then uses discounts to get to the end customer price. If no discounts are charged then the list price is charged.
3. Pricing Report for the next 30 Days - shows if I will be providing any other discounts over a certain timeframe.
Snippets of the extracts and the ideal output format are shown in the attachment. The reports need to capture all possible customer and product combinations and needs to be able to function as I continue to grow my product range and customers.
Design and target audience: Personal Use so format as per the attached Excel
Extra notes:
Carl D.
100% (11)Projects Completed
10
Freelancers worked with
10
Projects awarded
73%
Last project
6 Apr 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Please contact me I want to know how much are you willing to pay.
554394
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