Hello..
I have been trying to figure out how to do this..
I have a master spreadsheet that contains many part numbers, description, weight, price, ect...
Every month I receive an excel sheet that show what prices have changed, and only those that have changed.
Is there a way I can have excel change only the rows that match up to the part numbers that change?
Trying to (in english) say to excel.. "Look at the worksheet that contains the updated prices, if the part number matches on a certain row, change the price for that row to equal the price given on the changes worksheet."
Is this possible? If so can someone give me some guidance. Thanks!!!
And just for reference.. On worksheet "PriceUpdates506" the part number is Column A and the price is Column C
On the master spreadsheet I am trying to update, the partnumber is Column A and the price is Column F
Bookmarks