Em Andamento

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.

Habilidades: Processamento de Dados, Processamento de dados

Ver mais: 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

Acerca do Empregador:
( 3 comentários ) Aurora, CO, United States

ID do Projeto: #45837

Premiar a:

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 Mais

$50 USD em 2 dias
(1 Comentário)
1.4

15 freelancers are bidding on average $72 for this job

Indunil

Dear Sir, Already Finished. Pls Check PMB

$70 USD in 0 dias
(2 Comentários)
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 Mais

$89 USD in 6 dias
(2 Comentários)
3.0
dbteq

Ready to start. Thanks.

$65 USD in 4 dias
(1 Comentário)
2.5
ajay192

Please see PMB for details.

$100 USD in 4 dias
(1 Comentário)
2.5
vertexsoft

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

$30 USD em 1 dia
(3 Comentários)
1.9
sphuron

Ready to start the project. Best regards, Sphuron

$100 USD in 5 dias
(0 Comentários)
0.0
chandufree

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

$100 USD in 3 dias
(0 Comentários)
0.0
mequetrefe

ready to start, just let me know!

$100 USD in 5 dias
(0 Comentários)
0.0
phritzy

I can do this quick as possible. Regards

$40 USD em 1 dia
(0 Comentários)
0.0
freework

Please see PMB

$100 USD in 4 dias
(0 Comentários)
1.0
ramvinod

we are interested

$50 USD in 4 dias
(0 Comentários)
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 Mais

$60 USD em 1 dia
(0 Comentários)
0.0
smarc

Please see PMB. thanks

$30 USD in 3 dias
(0 Comentários)
0.0
trl208

please see pmb.

$90 USD in 7 dias
(0 Comentários)
0.0