View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
McLovin McLovin is offline
external usenet poster
 
Posts: 2
Default Comparing Spreadsheets from Different Sources

I have 2 spreadsheets, each from a different source. Both spreadsheets
contain a store number, SKU and SKU quantity except one of the spreadsheets
includes SKUs that the other one doesn't . . . and v/v. I need to create a
report that compares both spreadsheets and returns the differences. For
example, if one of the spreadsheets from Source A shows a quantity of 5 for
one SKU, but the other spreadsheet from source B doesn't list that SKU at all
I need it to return a qty of zero or just show a blank. HELP!