View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
srpettew
 
Posts: n/a
Default automatically updating summary worksheet

Hi,

I have several tabs (worksheets) representing purchases for a specific year.
There is one tab (worksheet) that is a Summary of all purchases for all
years. How do I get Excel to automatically update the Summary worksheet
anytime one of the other worksheets are modified?