Đã hoàn thành

vba code

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

Kĩ năng: Excel, Visual Basic

Xem nhiều hơn: vba code correlation monte carlo different distributions, filemaker products different prices calculation, yahoo historical vba prices, products different countries, code vba ftp, convertir code vba php, vba cut paste different sheet, gnenerate xml code vba excel, free javascript code customer ordering products, code vba refresh access, adding products different sizes magento, refresh button code vba, record microphone sourse code vba stop pause, convert lisp code vba, place products different menus virtuemart, optimization function code vba, ean code vba, ftp code vba, virtuemart show products different places, data entry products different detail, code vba pay, different products different countries, code vba excel primavera critical path, virtuemart products different color, online store php code users add products

Về Bên Thuê:
( 8 nhận xét ) Sydney, Australia

ID dự án: #13121470

Được trao cho:

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, Thêm

$15 AUD trong 1 ngày
(2 Đánh Giá)
2.0

8 freelancer đang chào giá trung bình $40 cho công việc này

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 regard Thêm

$34 AUD trong 0 ngày
(364 Nhận xét)
7.2
$30 AUD trong 1 ngày
(284 Nhận xét)
6.8
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........................... Thêm

$25 AUD trong 1 ngày
(12 Nhận xét)
3.8
langlangFan

** DO YOUR PROJECT FREE ** if this project improves my experience and you want long term relationship. Hello. Thanks for your job posting! I'm happy to bid on this project and have a relationship with you. I under Thêm

$111 AUD trong 1 ngày
(1 Nhận xét)
2.7
alsanchez65

A proposal has not yet been provided

$30 AUD trong 3 ngày
(1 Nhận xét)
0.6
$50 AUD trong 1 ngày
(0 Nhận xét)
0.0
victorhcc

I offer the lower bid. It is an easy task and I need the good feedback.

$25 AUD trong 1 ngày
(1 Nhận xét)
0.0
$24 AUD trong 6 ngày
(0 Nhận xét)
0.0