I have tried google, but not 100% sure of exactly what i am looking for, well how to describe it to google at least.

I have 2 spreadsheets for an online store, 1 is the CSV update with all active store products on it, the other is the suppliers main price list.

What i am trying to do is get some application or macro code to compare teh 2 sheets.

Update File has 4 fields, SKU, Product Name, Price, and Availability.

Suppliers sheet has many more Starting with SKU, Price incl, Price excl., Product Name and Descriptions.

What i would like to do i have is compare the SKU and Price inlc between the sheets and the if differences are found update it on the csv file.

The supplier sheet also has separations for different product categories on the 1 page, totalling about 60 000 rows. The separation rows just break the product areas and are not merged do the resulting scrip or application would need to search and replace not just flow down the column.

Any help or advice or even a link to an application that can do this would be greatly appreciated.