View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kelvin Lee
 
Posts: n/a
Default Get the sum value for every worksheet

Let say I got more than 20 worksheets in a workbook.
In B2 of Sheet1, I want a sum value of A1 in every worksheet.
Insteed of add up with '+' sheet by sheet. Any faster way for it?