The goal of this project is to create a VBA script (to use in the file "structure and filters", as described below) that will generate an excel file, called here "output file", with one sheet only, containing a product list with "tier prices".
A product can have max 3 rows for each different tier level and related price.
To generate the "output file" we will use 2 files.
The first file is the "database" file containing the "base product list". Each product has its own "base price", and there will be columns aimed to add details for each product, like "brand" -> "family" -> "group" -> "subgroup". This columns will be used in a second file, as described below.
The second file is used as "structure and filters" to understand which rows should be generated in the output file, in function of product code, subgroup, group, family or brand, with which tier levels and which price, for each tier level, to apply.
For any product in the "base product list" that have the same brand, family, group or subgroup exposed in the "structure and filters", will have to be generated in the "output file". On the same row in "structure file" will be exposed tier levels (in three columns maximum) and, for each tier level, the percentage of discount to apply to the base price exposed in the "product list" file.
For example: if the "product list" file contains 2000 products/rows, and 150 products has the column "subgroup" with the value "ABCDE", the script should look if the subgroup "ABCDE" exists in the "structure and filters" file and, if so, it should generated 3 rows in the "output file", one for each tier level found (in respective 3 columns), and it should calculate the price, getting the base price in the "product list" file and appling a specific % discount indicated in a specific column in the "structure and filters" price.
NOTE: the complete structure of the "output file" will be sent once the project will be assigned.
Greeting,
I have understood your Excel VBA task and can do it with your 100% satisfaction. Please ping me for more discussion.
Relevant Skills and Experience
I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic
Proposed Milestones
€150 EUR - excel VBA
Dear Employer,
I have read your job and I will do it for you. Please check my reviews. Request you to give me one chance. I am an expert.
Relevant Skills and Experience
Excel
VBA
MAcro
Proposed Milestones
€155 EUR - Project
Hi, I ll code the VBA macro which will generate the output file based on the 2 input files. We will do a sample 1-2 rows together to be sure that the logic of the generation is clear. Thanks
Expérience et Compétences appropriées
Excel/VBA Expert
Étapes proposées
€100 EUR - m
i understand your project, it's very simple work, i can do this please contact me thanks,
Relevant Skills and Experience
Data Entry, Data Processing, Excel, Visual Basic
Proposed Milestones
€155 EUR - full
I am a professional Freelancer. I would like to work on this project.
Excel expert here with more than 12 year's experience. Let's discuss and make this project a success, I can take up the project on urgent basis.
Relevant Skills and Experience
Excel
VBA
Proposed Milestones
€135 EUR - To be discussed
Hi, I can do that via Ms Access app with Excel automation.
Relevant Skills and Experience
I'm programming in ms Access/Excel/VB since Ms Office 97 released
Proposed Milestones
€155 EUR - default
Hi, I will create a macro to manipulate "product list" first. Macro will check rows one by one and if found "subgroup" then will go to second file "structure and filters" and find that subgroup code. If found then 3 rows will be added to "output file" and process according to required conditions.
Relevant Skills and Experience
Experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manipulating Data in Multiple Sheets and Creating Reports. I have done mostly Excel VBA Programming job.
Proposed Milestones
€80 EUR - initial
€75 EUR - final
Please let me know the OS. Windows or Mac?
We will discuss in details once you replied.
Hi,
I read you project description and I'm Dynamic Professional has good command on Office tools like (Excel, Word, VBA, Macro and Data Entry). I will done it as per your requirement. Thank You
Relevant Skills and Experience
Data Entry, Data Processing, Excel, Visual Basic
Proposed Milestones
€194 EUR - Final Delivery
I developed many projects with Excel that include VBA/macros. Please check my portfolio.
Relevant Skills and Experience
My skills are in programming with languages like Excel, Python, C#. I have an experience of 5 yrs.
Proposed Milestones
€111 EUR - Complete the whole project.
I guarantee you a first class service with the quality and in the time it deserves by putting at your disposal all my knowledge and years of practice.
Habilidades y experiencia relevante
Advanced proficiency on Microsoft Offices. Excellent team work and collaboration through influencing skills in the project. Strong attention to detail and ability to manage multiple priorities.
Htos propuestos
€250 EUR - Development and materialization of the requirements
Hello Sir, I am Saiful. I can help you on this project. Thanks
Relevant Skills and Experience
I am Digital Merketer
Proposed Milestones
€170 EUR - mileston
I am Data Entry/Data Processing Expert I am the Right person for you
Sir, I'm interested in your project. Please send me a message so that we can discuss
more
Relevant Skills and Experience
Sir, I'm interested in your project. Please send me a message so that we can discuss
more
Proposed Milestones
€111 EUR - Please send me a message so that we can discuss more
We will be able to complete the work with better quality.
Relevant Skills and Experience
We are very experienced in excel. We will be able to provide the work with the stipulated time.
I would like to start working on the project, and look forward to achieving the required task properly,Accurately and be able to meet deadline.
Relevant Skills and Experience
Excel files, attention to details, meet deadline, typing, data entry