View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trace Trace is offline
external usenet poster
 
Posts: 5
Default transfer total from one sheet to another

I have a workbook with about 10 sheets. In each sheet there are total in j2,
h2, and L2 (same in each sheet). I want these totals to appear in a total
sheet; say with name of sheet then the three totals. I can seem to do this.
pls help.