Käynnissä

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.

When I went to post this project, I see that "Project for dsendra" has given me a rating of 1, this is too bad because they have never contacted me (as they state) about following up on a project that I awarded to them. I make the same claim that I did try to contact them (at the end of December, 2005), but never heard from them either.... I however have not down graded/rated them for the missed communication.

All this to say that I know this is a small project and I hope that the rating will not discourage anyone from bidding.

Taidot: tiedonsyöttö, tietojenkäsittely

Näytä lisää: price update script, excel price update macro, will price, price file, excel &, data entry macro, price update macro, excel price update, update script excel, excel macro update prices, dynamic price updater excel, xls spreadsheet template price update, update scrip price excel, excel macro mssql handle exceptions, scrip price excel updated, excel macro price update, excel macro update mssql, macro update script, excel macros pricing, update cost cost excel, excel macro update sql, update price using excel macros, excel macro price, price update excel, check price updates script

About the Employer:
( 3 reviews ) Aurora, CO, United States

Projektin tunnus: #45837

Myönnetty käyttäjälle:

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 Lisää

50 $ USD 2 päivässä
(1 arvostelu)
1.4

15 freelanceria on tarjonnut keskimäärin 72 $ tähän työhön

Indunil

Dear Sir, Already Finished. Pls Check PMB

70 $ USD 0 päivässä
(2 arvostelua)
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 Lisää

89 $ USD 6 päivässä
(2 arvostelua)
3.0
dbteq

Ready to start. Thanks.

65 $ USD 4 päivässä
(1 arvostelu)
2.5
ajay192

Please see PMB for details.

100 $ USD 4 päivässä
(1 arvostelu)
2.5
vertexsoft

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

30 $ USD 1 päivässä
(3 arvostelua)
1.9
sphuron

Ready to start the project. Best regards, Sphuron

100 $ USD 5 päivässä
(0 arvostelua)
0.0
chandufree

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

100 $ USD 3 päivässä
(0 arvostelua)
0.0
mequetrefe

ready to start, just let me know!

100 $ USD 5 päivässä
(0 arvostelua)
0.0
phritzy

I can do this quick as possible. Regards

40 $ USD 1 päivässä
(0 arvostelua)
0.0
freework

Please see PMB

100 $ USD 4 päivässä
(0 arvostelua)
1.0
ramvinod

we are interested

50 $ USD 4 päivässä
(0 arvostelua)
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 Lisää

60 $ USD 1 päivässä
(0 arvostelua)
0.0
smarc

Please see PMB. thanks

30 $ USD 3 päivässä
(0 arvostelua)
0.0
trl208

please see pmb.

90 $ USD 7 päivässä
(0 arvostelua)
0.0