Excel Spreadshhet compare

**CranialBlaze** · 04-21-2009, 05:04 AM

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.

**Leith Ross** · 04-21-2009, 09:03 PM

Hello CranialBlaze,

Welcome to the Forum!

It would be best if you could post samples of both workbooks. Creating a solution for this depends on knowing the layouts of both workbooks. If you have sensitive or confidential information, change it before posting. Also, if you are using Excel 2007 then you should post a copy of the Workbook in Excel 2003. This will give you greater exposure and faster answers.

**CranialBlaze** · 04-22-2009, 02:40 AM

Attached is a workbook with 2 sheet representing the workbooks that need to be updated, Sheet 1 is a snippet from the suppliers pricelist and sheet 2 is the corresponding data that would be updated by it for the CVS import into the store.

The SKU column as is wont match up with the product codes from the suppliers pricelist, originally before CSV updating was a viable option i used my own SKU's but should i be able to achieve the desired results through some help from you guys i will then change all sku's to correspond.

The suppliers pricelist has 2 pricing columns, the price that the csv file would need to check is the 1st price column adjacent to the Product Codes.

The document is in 2003 Format

**ravishankar** · 04-22-2009, 03:51 AM

HI
try these codes

Please Login or Register  to view this content.

It will replace the price in sheet 2 if it does not match in sheet1 and colors it yellow.
Ravi

**CranialBlaze** · 04-22-2009, 05:44 AM

Thanks, that awesome, works like a charm, ("Supplier Price List") i was just using this against 1 price list, now 1 or 2 of my suppliers have books with multiple sheets so would it be correct if i update the correct string for example to ("Sheet 1"; Sheet 2") that way it will compare data against all sheets.

Thanks again