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
Bookmarks