Excel compare and update changes

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

caryn

Thread Starter
Joined
Feb 8, 2005
Messages
16
I have a supplier price list emailed to me weekly as an excel(2002) document. It contains a lot of items I don't use, so I've altered the original document to contain only the rows I require.
What I would like to do is when I receive a new spreadsheet weekly, to compare the data to my original sheet by product code, and if the price has changed update it on my original sheet. If it hasn't changed make no alteration. I also want to ignore product codes listed on the new price list that do not appear on my original (sorry this sounds muddled, I don't know how else to explain it).

The data is in columns of :
A - Product Code (combination of letters and numbers)
B - Product Name
C - Price

So ... compare the new sheet to the old sheet. If a product code from the old sheet is listed on the new sheet and the price is different, change the price on the old sheet. If a product code on the new sheet does not appear on the old sheet ignore it.

Hope someone can help, wasn't sure how to word my query to look on the MS site.
Cheers
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top