Đang Thực Hiện

Excel Macro - Price update script

I have a price file that I receive updates for every three months. I have modified the stock number in the price file by adding 3 digets and a space to the front of each number and using that new number in the inventory file. I need a macro or access written program that will compare the number in the NEW PRICE FILE and find it's match in the INVENTORY FILE and then compare the new price found in the NPF and update the IF with the new price. There is also six colums that need to change which are price levels and are bases on the new price. I also require an 'exception' report that will gather all the items that did not find a match. I've included two example worksheets in one file (you will actually be working with two excel spreadsheets), 1) the NEW PRICE FILE (NPF) that I recieve every three months and the INVENTORY FILE (IF) which is the file that I need updated (it's the preious update from 3 months ago). This example shows the set-up and for those who are interested in the project, I'll send the two complete spreadsheets. The NPF has 10114 items and the IF has 11418 items. I would like this to be flexable enough that the process could be done on any two spreadsheets, by just 'plugging' in the required colums to compare and fill out.. and again don't forget about an 'exception' report for those matches that are not found.

Kỹ năng: Nhập liệu, Xử lí dữ liệu

Xem thêm: price update script, excel price update macro, will price, price file, data entry macro, price update macro, excel price update, update script excel, excel macro update prices, dynamic price updater excel, update scrip price excel, scrip price excel updated, excel macro price update, excel macro update mssql, macro update script, excel macros pricing, excel macro update sql, excel macro price, price update excel, check price updates script, updatescript excel, exel macro updates sends, excel macro cost, php excel macro script, java price update script

Về Bên Thuê:
( 3 nhận xét ) Aurora, CO, United States

Mã Dự Án: #45837

Đã trao cho:

attagill

The Macro (VBA Program) in MS Excel would be made with a userfriendly interface, that is a Window with GUI elements like buttons, checkboxes etc and would be available globally, that is could be invoked from any of the Thêm

$50 USD trong 2 ngày
(1 Đánh Giá)
1.4

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

Indunil

Dear Sir, Already Finished. Pls Check PMB

$70 USD trong 0 ngày
(2 Đánh Giá)
3.5
cstl

Chandusoft is a customer-specific service oriented company has got an Professional and creative team with 6 years experience in Web design and development. We have expertise and experience in ecommerce site development Thêm

$89 USD trong 6 ngày
(2 Đánh Giá)
3.0
dbteq

Ready to start. Thanks.

$65 USD trong 4 ngày
(1 Đánh Giá)
2.5
ajay192

Please see PMB for details.

$100 USD trong 4 ngày
(1 Đánh Giá)
2.5
vertexsoft

Is a very simple project that we can deliver for you in only one day! Please contact us! Regards!

$30 USD trong 1 ngày
(3 Đánh Giá)
1.9
sphuron

Ready to start the project. Best regards, Sphuron

$100 USD trong 5 ngày
(0 Đánh Giá)
0.0
chandufree

I'm interested in your project. Please contact me as soon as possible. Thank you.

$100 USD trong 3 ngày
(0 Đánh Giá)
0.0
mequetrefe

ready to start, just let me know!

$100 USD trong 5 ngày
(0 Đánh Giá)
0.0
phritzy

I can do this quick as possible. Regards

$40 USD trong 1 ngày
(0 Đánh Giá)
0.0
freework

Please see PMB

$100 USD trong 4 ngày
(0 Đánh Giá)
1.0
ramvinod

we are interested

$50 USD trong 4 ngày
(0 Đánh Giá)
0.0
kmohan1962

Hello Sir, Thank you for your project. I've peeped in excel file 2 sheets. It seems your work will be very simple. I believe you wanted a template to get updated rate in your IF from PF. I'll design in such a way Thêm

$60 USD trong 1 ngày
(0 Đánh Giá)
0.0
smarc

Please see PMB. thanks

$30 USD trong 3 ngày
(0 Đánh Giá)
0.0
trl208

please see pmb.

$90 USD trong 7 ngày
(0 Đánh Giá)
0.0