View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
E E is offline
external usenet poster
 
Posts: 2
Default Compare 2 pivot tables and report differences

I have a monthly report showing forecast planned orders
that is pulled weekly.I need to compare the week to week data and report the
differences in item and qty.
I need to show what items that may have disappeared
and how much and what data has appeared and how much and the difference
between items that are still there.
Any ideas?
TIA