Verify spreadsheet content

[Tess1950]

I need to compare the contents of two spreadsheets. the first is a subset of the second. Both have a product number as a unique identifyer. I need to validate that the information in the first spreadsheet matches that in the second, for the subset of products listed in the first.

e.g.:

first
Product number Desired value

Second
Product number Value

I need to make sure that the desired value actually got loaded and is now the value.

any suggestions? (I'm not a programmer, so writing a macro is probably beyond my capability!)

Thanks!
Tess

[Bernie Deitrick]

"spreadsheets" is too generic a term - sometimes it means a workbook (a separate file) and sometimes it means a separate sheet within a workbook.

If you have two workbooks, insert a copy of the second workbook's worksheet into the first workbook. Now you have two worksheets within one workbook. If you already had two worksheets within one workbook, you can skip this first step.

I have assumed that you have "Sheet 1" and "Sheet 2", Sheet 2 is the subset of data, and that the unique identifiers are in column A of each, and that the columns of both sheets are the same, and are in the same order.

Select all the cells on Sheet 2, starting with cell A1. Then apply Conditional Formatting, choosing the formula option, and use the formula

=VLOOKUP($A1,'Sheet 1'!$1:$10000,COLUMN(A1),FALSE)<>A1

Of course, change the Sheet 1 part of the formula to the actual name of the first sheet. Then, select red as the fill color, and apply the CF.

Any cells that are red were changed from the original value on Sheet 1.