vba code

$10-30 AUD

Completed

Posted

about 7 years ago

$10-30 AUD

Paid on delivery

Hi, I would like the VBA code for multiple lookups, done through a looping macro. I have three columns in a worksheet. The first column contains a list of dates and the second column contains a list of product codes. I am trying to populate the third column with the price of the product. In a different worksheet I have three columns, which contains the product codes, dates and the prices for each of the products. The issue is the price of the product changes each year for each product, so I need to find the price of each product after the most recent price increase for each product. I've attached a file for an example, the file contains the two tabs for the macro. I would like the yellow column populated with the result. Can someone please help with the VBA for this example, thanks Sorry, the example I attached has 3 conditions to match in the first sheet. The VBA code also needs to match the product type in column B, thanks again

Excel

Visual Basic

Project ID: 13121470

About the project

7 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now

$15 AUD in 1 day

4.4

(19 reviews)

3.8

7 freelancers are bidding on average $30 AUD for this job

@cgullapalli

Hi, Please verify your account in order to start chat. I am not able to send message to you. I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat. and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra

$34 AUD in 0 day

5.0

(866 reviews)

8.0

@jnekam

Hi There, you can build a data base of prices and make a simple vlookup. The technique will work for long time VBA will hard to write for that and is not flexible as using formulas Thanks....................................................................

$25 AUD in 1 day