View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Excel programming: change detection

http://www.cpearson.com/excel/duplic...#InOneNotOther

-----Original Message-----
Hi!

I am a total freshman in Excel programming. I need help

in the following
problem (preferably for Excel 2000, if there's a

difference):

- I have a very large retail price list in Excel format

(more than 5000
products)
- every week I get a new net price list from my wholesaler
- the new net price list includes also new products and

(sometimes) changes
to product prices etc


I need a set of Excel macros to use to compare my price

list and my
wholesaler's price list to find

- new products (every product has a unique product number)
- changed products (price and/or any other feature)


The result of these macros should be:

- either a separate sheet with only the new products/only

the changed
products included
- or some way to mark the rows on the new net price list

that have changed


Even better would be if I could make this process totally

automatic,
resulting to my original retail price list being updated

automatically,
every time I get a new net price list


I thank everyone trying to help me,
Jari Tuomi,
Finland
eMail:





.