Find Jobs
Hire Freelancers

Multiple Supplier Price list amalgamation tool

$30-250 USD

Closed
Posted over 3 years ago

$30-250 USD

Paid on delivery
What I want: A tool / formula to amalgamate my supplier price lists into one price list on a regular basis. The problem: The databases from the the suppliers have overlapping products, but the products don't share the same SKU's or other matchable strings except for the description. We would like to import these price lists into one list and for the tool to search the list with duplicate stock and take the stock item with the best price. From the little research I have done, you can do this by using macros / VB. Attached a few samples of price lists.
Project ID: 26814372

About the project

17 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $134 USD for this job
User Avatar
Hi, Greetings! ✅checked your project details: Multiple Supplier Price list amalgamation tool ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$180 USD in 4 days
4.9 (432 reviews)
8.3
8.3
User Avatar
I can perfectly help you in developing such a dynamic tool. I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
$50 USD in 1 day
4.7 (108 reviews)
6.2
6.2
User Avatar
Dear Client, i will create a master file that displays all the items with their relative supplier and other details as needed. For the price list, we can automate the process to select the best price if we have a match of the description. It will all be presented in an easy to use, fresh dashboard that can be customized according to your requirements and taste. Let us discuss more over chat. John
$150 USD in 7 days
5.0 (45 reviews)
5.0
5.0
User Avatar
Hi, As you investigated and correctly found, the solution would be a VBA code/macro that merge your supplier prices lists. Let's discuss more details on PMB. Regards, Ramin.
$200 USD in 4 days
5.0 (28 reviews)
4.6
4.6
User Avatar
HI! I am an engIneer and Excel/VBA/Macro expert and Google Scrpit , Google Sheets expert too. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script). Regards, Juan
$140 USD in 7 days
5.0 (14 reviews)
4.3
4.3
User Avatar
Your task seems easy but let us chat about this task and make sure you will get the best waiting for your reply Thanks E
$111 USD in 2 days
4.4 (7 reviews)
3.4
3.4
User Avatar
Hi, We have worked on several excel data and macro projects with an experience of over 7 years on excel macro programming. We can write a macro to compare the price list of suppliers based on its description and result out the best price. Please contact us and discuss further and start the work. Thank you.
$89 USD in 2 days
5.0 (10 reviews)
3.0
3.0
User Avatar
Hello I have read requirement very carefully and i can complete it perfectly in short time. I am a new freelancer, But I am very confident with my skills and I have rich experience in these fields. I can use the ASP.Net and VB.Net, JQuery to complete your project. I have done this kind of work several times so I know how to do this. I'd like to help your business by doing my best. If you hire me, I will do my best for you. Let's meet and discuss more. Best Regards.
$140 USD in 2 days
5.0 (3 reviews)
1.8
1.8
User Avatar
I am read and understand of your project .Iam able to Complete this job very best quality and accuracy because I have been working as a Data Entry work at least 3 years . I promise to provide best quality and accuracy . Regards prasanth kumar
$148 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello There, Greetings of the day !! I have read your requirements carefully and wish to apply for this job if i am eligible. I am available to work for 9 hours per day. I have expertise in these areas - Data Entry, Typing Skills, Web Research for data extraction. I do have knowledge about Google SpreadSheets, Google Docs, Microsoft Office [Word, Excel (Basic), PowerPoint]. I do my work 100% error free and as instructed by the employer. No compromises with the work quality at all. I do complete the given task before deadlines.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a reliable, highly punctual and fast person when typing on PC, so I can deliver you the work in less than the time you are asking to be delivered at. Also I have experienced regarding word for more than 7 years, so I can assure you that the work would be delivered not only quickly, but also accurately and with no mistakes.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I sure can deliver an good solution to your proposed problem, I will just need to understand some details with you first, if interested please call me on chat so we can discuss those details in order to deliver the best solution possible.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi sir, very good day to you . I have gone through your requirement ,, yes by macro it can be achieve . I can do it for you , please award this project thanks
$167 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
South Africa
0.0
0
Member since Aug 20, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.