View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elgee Elgee is offline
external usenet poster
 
Posts: 24
Default Sum worksheets - w/o updating formula for new worksheets which are

Hi -
I know how to sum fields of various worksheets. However, can I set the
formula so that if a new worksheet is added, the formula will automatically
update to include the new worksheet? (Data in the same cell as other
worksheets.)

Thank you!!