View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
potentus potentus is offline
external usenet poster
 
Posts: 4
Default Compare 2 excel workbooks

Hi,

I have 2 excel sheets generated daily :
Daily a
Daily b

I need to compare column A in "Daily a" to Column a in "Daily b" and
show all items that dont appear in both (deltas)
So for example the number 1 only appears in "Daily a" it would be
listed, but if it was in both daily spreadsheets it would not


Thanks


Neo