En cours

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.

Compétences : Saisie de Données, Traitement de Données

Voir plus : 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

Concernant l'employeur :
( 3 commentaires ) Aurora, CO, United States

N° du projet : #45837

Décerné à :

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 Plus

50 $ USD en 2 jours
(1 Commentaire)
1.4

15 freelance ont fait une offre moyenne de 72 $ pour ce travail

Indunil

Dear Sir, Already Finished. Pls Check PMB

70 $ USD en 0 jours
(2 Commentaires)
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 Plus

89 $ USD en 6 jours
(2 Commentaires)
3.0
dbteq

Ready to start. Thanks.

65 $ USD en 4 jours
(1 Commentaire)
2.5
ajay192

Please see PMB for details.

100 $ USD en 4 jours
(1 Commentaire)
2.5
vertexsoft

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

30 $ USD en 1 jour
(3 Commentaires)
1.9
sphuron

Ready to start the project. Best regards, Sphuron

100 $ USD en 5 jours
(0 Commentaires)
0.0
chandufree

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

100 $ USD en 3 jours
(0 Commentaires)
0.0
mequetrefe

ready to start, just let me know!

100 $ USD en 5 jours
(0 Commentaires)
0.0
phritzy

I can do this quick as possible. Regards

40 $ USD en 1 jour
(0 Commentaires)
0.0
freework

Please see PMB

100 $ USD en 4 jours
(0 Commentaires)
1.0
ramvinod

we are interested

50 $ USD en 4 jours
(0 Commentaires)
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 Plus

60 $ USD en 1 jour
(0 Commentaires)
0.0
smarc

Please see PMB. thanks

30 $ USD en 3 jours
(0 Commentaires)
0.0
trl208

please see pmb.

90 $ USD en 7 jours
(0 Commentaires)
0.0