Find Jobs
Hire Freelancers

Inventory Price Update

$250-750 USD

Closed
Posted over 1 year ago

$250-750 USD

Paid on delivery
Exported inventory list from QuickBooks to Excel. Converted vendor price list from PDF to Excel. Imported both as sheets into a new workbook, where I started formulas to say IF a vendor's part number for an item in the QuickBooks sheet matches a part number in the vendor list, copy the vendor's new price to a new column next to the old price. Then have a column which calculates the percentage change from the old vendor price to the new vendor price for each item found. Kinda got one column working, except it doesn't look for BLANK SPACES, so the outputted column data is about 50% blanks.
Project ID: 35002743

About the project

52 proposals
Remote project
Active 1 yr 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
52 freelancers are bidding on average $413 USD for this job
User Avatar
Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + 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
$400 USD in 5 days
4.9 (555 reviews)
8.4
8.4
User Avatar
بسم الله الرحمن الرحیم I can do your project in less than 24 hours with full delivery and without error In Sha Allah,
$250 USD in 1 day
4.9 (172 reviews)
6.5
6.5
User Avatar
Hi there,I'm biddin on your project "Inventory Price Update" I have read your project description and i'm an expert in mathematics and machine learning therefore i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. .. .
$750 USD in 6 days
5.0 (9 reviews)
6.1
6.1
User Avatar
Hi I hope all's well with you. I'm an Access/Excel/SQL/VBA expert and a mathematician from Georgia- a full-time freelancer. I have been coding for over 20 years in this field. I can code/fix your Excel file. You will be very happy. Please visit https://www.freelancer.com/u/zu02?w=f Thank you and best Regards from Zurab
$250 USD in 7 days
4.8 (46 reviews)
6.2
6.2
User Avatar
Hi, I can develop Excel VBA Macro as per your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$250 USD in 3 days
4.8 (139 reviews)
6.1
6.1
User Avatar
Hi! I have read your job description carefully and have checked the attached file, I can write you VBA/MACRO code to perform this task of checking part number, copy the price and calculating the percentages, I will hardly take 2 hrs to get you this job done, i can start immediately, text me to discuss more...
$250 USD in 1 day
5.0 (35 reviews)
5.3
5.3
User Avatar
Greetings, This is Umair I am familiar with your project skills Excel, Data Processing and Visual Basic. I have done similar projects before. Let's have a quick chat on this project to clear further details and I will give you development feedback as soon as possible. I am a Full Stack developer for Excel, Data Processing and Visual Basic. Looking forward to working with you. Thanks Umair A.
$700 USD in 25 days
5.0 (2 reviews)
4.8
4.8
User Avatar
Hello I have read project details and check file . I can do this project . Need little more clarification in details I have 15+ year experience in Excel, Excel VBA, Python and have 100% feedback So, you can trust to me. Result will be excellent Best Regards
$250 USD in 1 day
5.0 (44 reviews)
4.8
4.8
User Avatar
VBA, Excel, Python, R, Mathematics, Finance, Data Processing, Macros skilled professional with over 9 years of experience. Can build a solution as needed and deliver on the expected lines. Thanks
$500 USD in 3 days
5.0 (18 reviews)
4.2
4.2
User Avatar
Yo, Inventory Maker engineer I have read your project sir and check your attachment xlsx file I can finish your project in 40 hour's and i want to you come to the chat so we can easily discuss Cheer's
$350 USD in 2 days
4.9 (6 reviews)
4.5
4.5
User Avatar
Hi, I am very glad to bid on your job posting. I am not only talented programming developer, but also excel master. I can contact with you anytime you want and I can work for you as a full time developer. It's my pleasure to help you. If you hire me, I can complete your project with 100% accuracy. Please see my Portfolios and reviews to know more about me.
$500 USD in 1 day
5.0 (5 reviews)
3.2
3.2
User Avatar
''Inventory Price Update'' Hello, this is Bryson Henniger here. Yes! I scrutinized the appended sheet. When do you need this to be done? Waiting for your reply. Thanks!
$500 USD in 8 days
4.8 (2 reviews)
2.1
2.1
User Avatar
Hello Sir or Ma'am, My name is Trent, I'm a business analyst from Wisconsin. I took a shot at your TechRack Pricing file and found 1510 records in the QB sheet with valid MPN values (non-blank). Of those 1510 MPN value records, I was able to match 442 records to new prices in the Table1 sheet and calculate the price change. I'd be happy to share the updated file with you and discuss what else I can help you with to earn your business. Thanks, Trent
$250 USD in 2 days
5.0 (1 review)
1.6
1.6
User Avatar
Hello, I concluded that you are changing the price and not evaluating the current stock and I hope I was right. Iam excited to work with you and I wish you success in your project. I opened the source file from QuickBooks and I can do this inventory in a day. I can suggest you some additions that will help you in this work next time. Thank you
$250 USD in 2 days
5.0 (1 review)
0.4
0.4
User Avatar
Hey there, I have worked on similar project so i can help u with it. Please contact me as I can help u with Data Processing, Excel and Visual Basic. Here is a link to my profile: https://www.freelancer.com/u/ayesha0124 Regards
$750 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi, this is a regular work doing by my subordinate and i supervise them , timely price update in retail chain store is going done by every day with the ratio of percentage, it will be done very easily i am well aware from this practice to making comparisons between vendor price.
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
B tech graduate with hand on experience with data analytics and inventory management of e commerce company, thought I am cable to take your project and finish it within time frame given
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have read project details and check file . I can do this project . Need little more clarification in details I have 8+ year experience in Excel, Excel VBA, Python and have 100% feedback So, you can trust to me. Result will be excellent Best Regards
$250 USD in 4 days
0.0 (0 reviews)
1.1
1.1
User Avatar
Worked 5 full time years with multiple MNCs and gained skills under project management, business data analytics, reporting, presentation, knowledge base/catalogue development, customer support, technical support, recruitment and training. I enjoy simplifying complex data structures in excel to generate business insights.
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I went through your requirements and I can help you to achieve your goal and fix excel formula. I can use raw data and clean it in different way so that it will return result output as you expect. I have 17 years of experience and I'm certified Data analyst by Udacity and DataCamp. Looking forward to chat with you to discuss more details. Thanks Hany
$400 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Plano, United States
0.0
0
Member since Oct 22, 2022

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.