View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
יהונתן טבת יהונתן טבת is offline
external usenet poster
 
Posts: 5
Default updating Excel workbook

Hi,

I am using an Excel workbook with 10 worksheets.
Every worksheet has lists of different names and different amounts.
The tenth worksheet needs to have in it the updated summation of all nine
other worksheets.
In other words the tenth worksheet will have the sum of all the others at
any given time.
The problem: the first nine worksheetsare being updated on a daily basis.
Is there a way to update the tenth worksheet automatically as per the nine
other worksheets?
Thank you.