Find Jobs
Hire Freelancers

Excel VBA Macro needed to perform Vlookup Function

£20-250 GBP

Slutfört
Publicerad ungefär fem år sedan

£20-250 GBP

Betalning vid leverans
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.
Project ID: 18770551

Om projektet

29 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
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 Om 0 dag
5,0 (525 omdömen)
7,0
7,0
29 frilansar lägger i genomsnitt anbud på £89 GBP för detta uppdrag
Använd avatar
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 Om 0 dag
4,9 (139 omdömen)
7,8
7,8
Använd avatar
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 Om 3 dagar
5,0 (184 omdömen)
7,6
7,6
Använd avatar
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 Om 3 dagar
4,9 (283 omdömen)
7,8
7,8
Använd avatar
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 Om 0 dag
4,9 (239 omdömen)
7,5
7,5
Använd avatar
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 Om 3 dagar
5,0 (202 omdömen)
7,4
7,4
Använd avatar
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 Om 1 dag
4,9 (235 omdömen)
6,9
6,9
Använd avatar
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 Om 3 dagar
4,9 (55 omdömen)
6,5
6,5
Använd avatar
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 Om 3 dagar
5,0 (84 omdömen)
6,1
6,1
Använd avatar
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 Om 1 dag
5,0 (101 omdömen)
6,1
6,1
Använd avatar
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 Om 2 dagar
5,0 (31 omdömen)
5,9
5,9
Använd avatar
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 Om 3 dagar
5,0 (99 omdömen)
6,1
6,1
Använd avatar
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 Om 3 dagar
4,8 (50 omdömen)
5,8
5,8
Använd avatar
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 Om 3 dagar
4,7 (65 omdömen)
5,6
5,6
Använd avatar
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 Om 2 dagar
5,0 (22 omdömen)
5,3
5,3
Använd avatar
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 Om 3 dagar
4,7 (33 omdömen)
5,8
5,8
Använd avatar
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 Om 0 dag
5,0 (25 omdömen)
4,6
4,6
Använd avatar
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 Om 1 dag
4,4 (48 omdömen)
4,6
4,6
Använd avatar
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 Om 1 dag
5,0 (9 omdömen)
4,0
4,0
Använd avatar
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 Om 3 dagar
4,5 (6 omdömen)
3,7
3,7
Använd avatar
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 Om 3 dagar
5,0 (7 omdömen)
3,2
3,2

Om kunden

Flagga för UNITED KINGDOM
Ashton-under-Lyne, United Kingdom
5,0
14
Verifierad betalningsmetod
Medlem sedan sep. 22, 2012

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.