Find Jobs
Hire Freelancers

Excel VBA Macro needed to perform Vlookup Function

£20-250 GBP

已完成
已发布大约 5 年前

£20-250 GBP

货到付款
I have a spreadsheet with part numbers and costs stored in it. I need to be able to paste daily sales data into a new sheet (sales) on the spreadsheet and then run a macro that will go through each row and enter the cost price for the part sold from the other sheet (costs). I need the cells to contain actual data and not a formula, that is why I want to use a macro. If the part on the sales sheet cannot be found in the costs sheet then the price should be set to 999. The macro needs to have the ability to work with varying number of rows in the sales and costs sheet.
项目 ID: 18770551

关于此项目

29提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hello, this is definitely possible and its a common request. If you are interested in working with me, feel free to message me and i will try to help immediately. Usually vlookup macros like this don't take more than an hour to code. Thanks, Milan
£28 GBP 在0天之内
5.0 (525条评论)
7.0
7.0
29威客以平均价£89 GBP来参与此工作竞价
用户头像
Dear Client I am an experienced VBA developer and have served the clients throughout the globe. Please have a look at my profile to get an insight into the quality of my services. I have reviewed your job and ready to proceed to complete right away. Will be waiting for your response to proceed further. Warm Regards Z
£77 GBP 在0天之内
4.9 (139条评论)
7.8
7.8
用户头像
Dear Employer, I will build the macro as per your specification of sales and cost sheets. Please share the sheets so that I can analyse what exactly do you require. Thanks and Regards, Ash
£100 GBP 在3天之内
5.0 (184条评论)
7.6
7.6
用户头像
Hi, my name is Selim. I am from Solihull, UK. I read your `Excel VBA Macro needed to perform Vlookup Function` project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I would like to see your template if you don't mind... I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
£100 GBP 在3天之内
4.9 (283条评论)
7.8
7.8
用户头像
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have a macro in Excel to update values in your sheet or add 999 if a match is not found. The macro will scan the rows no matter how many they are. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in six years, and I feel confident to complete your project as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you 70 pounds and can deliver within 2-3 hours (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
£70 GBP 在0天之内
4.9 (239条评论)
7.5
7.5
用户头像
Hi, I have been working on Excel macro based projects for quite some time and would be happy to take on your project. I can deliver the macro fulfilling all the rules you have spelt out in the description. Let me know if you are interested. Cheers, Arul
£100 GBP 在3天之内
5.0 (202条评论)
7.4
7.4
用户头像
Hello Joe, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
£50 GBP 在1天之内
4.9 (235条评论)
6.9
6.9
用户头像
Hi, You may not select the right candidate without knowing what your project on building an Excel VBA Macro needed to perform Vlookup Function will look like. Fortunately, I can complete a part of your job before you award the project. Before you award this project, I can complete a part of this project as a sample. I can start by writing the macro that will go through each row and enter the cost price for the part sold from the other sheet (costs).This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more about what would make this project a success for you. Can we have a quick chat? Thanks for your time.
£150 GBP 在3天之内
4.9 (55条评论)
6.5
6.5
用户头像
Hi, As per requirements I will develop VBA macro for you which will copy the pricing data as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I am ready to work on this project now. Please give me this opportunity to work on your project. Thanks and regards, Mohan
£99 GBP 在3天之内
5.0 (84条评论)
6.1
6.1
用户头像
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully, I can write the marco to calculate cost price for varying numer of rows as requested. You’re welcome to checkout my reviews and project completion rate to have some idea about the quality of my previous works, Would be great if you can provide a sample of your workbook for more context. Kindly get back to me if you wish to proceed, I am available to start your project immediately, looking forward to discuss further and work on your project.
£80 GBP 在1天之内
5.0 (101条评论)
6.1
6.1
用户头像
Hi Excel expert here with 12 years of programming experience. I can write the required VBA to loop through the cost sheet and fetch the cost for each of the item in the main sheet - same function a vlookup formula does. Look forward to hear from you. Thanks Roni
£45 GBP 在2天之内
5.0 (31条评论)
5.9
5.9
用户头像
Hello, I am Excel and VBA expert. I understand the requirements. I can do it in VBA (Excel VBA macros).Could you provide the file? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan
£44 GBP 在3天之内
5.0 (99条评论)
6.1
6.1
用户头像
Hello there, I understand that you require a Vlookup function through VBA to find the cost price for sets of data. I am the right candidate for your requirements as I am a professional freelancer with Advance skills in the MS Excel. I request you to visit my portfolio page to see the sample work. We can discuss it further over a chat. Thanks.
£150 GBP 在3天之内
4.8 (50条评论)
5.8
5.8
用户头像
1. I am an expert in Excel,VBA,and also expert in vlookup functions, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
£100 GBP 在3天之内
4.7 (65条评论)
5.6
5.6
用户头像
Hi, I can write the VBA script to match the data between the sheets and fill the corresponding values. Best regards, Florin Enache
£100 GBP 在2天之内
5.0 (22条评论)
5.3
5.3
用户头像
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel /VB. As my vba/Excel coding experience shows , here need to use ADO/SQL vba coding within Excel- I've code several Excel tasks like that. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects. I do what it takes. Thank you for your consideration. Zura
£150 GBP 在3天之内
4.7 (33条评论)
5.8
5.8
用户头像
Hello. Below are examples of my recently completed VA project Smart VBA Excel Sheet - https://www.freelancer.com.ru/projects/data-entry/vba-excel-compare-count-sort/?w=f Flexible VBA customized drop down menu in excel - https://www.freelancer.com.ru/projects/excel/excel-task-drop-down-menu/?w=f Your task can be completed today. It will be flexible VBA code that will work with any number od rows required.
£90 GBP 在0天之内
5.0 (25条评论)
4.6
4.6
用户头像
Hi, I am an Excel Expert with very good knowledge of VBA. I can write codes to perform this look up. Please come on chat for more details. Thank you Awaiting your response.
£50 GBP 在1天之内
4.4 (48条评论)
4.6
4.6
用户头像
Hi, I can write this macro for you in less than 1 hour, also if you need to do more for your data by VBA I'm glad to help ;-)
£20 GBP 在1天之内
5.0 (9条评论)
4.0
4.0
用户头像
Hi,I have read your description carefully and have full experience in this field. You will be satisfied about my working result if I have chance of completing your project. I have ability to help you using skill you required and can be realized it anytime. I expect to complete this project with you. Myskills: excel, excel macro, google sheet, excel vba, visual basic
£150 GBP 在3天之内
4.5 (6条评论)
3.7
3.7
用户头像
Hi I assume cost sheet contains 2 columns, Part_Nr, Price. Part_Nrs are unique, or made unique. sales sheet contains at least 2 columns, Part_Nr, Price. Price column is NOT filled. We make a dictionary of key/value pair of Part_Nr, Price Going down Part_Nr in sales sheet, Excel knows the Price if Part_Nr exists in dictionary; if Part_Nr does not exists in dictionary, it sets the Price as 999 There is no restriction to number of rows in sales sheet. The cost sheet can have 10,000 or 100,000 rows. Dictionary makes matching very fast. I am confident to complete the assignment within 3 calendar days once the sample cost and sales sheets are available please. Regards KC
£88 GBP 在3天之内
5.0 (7条评论)
3.2
3.2

关于客户

UNITED KINGDOM的国旗
Ashton-under-Lyne, United Kingdom
5.0
14
付款方式已验证
会员自9月 22, 2012起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。