View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hsg hsg is offline
external usenet poster
 
Posts: 40
Default copy days total to other worksheet

My data has following pattern
A B C
1-2-2009 5 5
1-2-2009 8 13
1-2-2009 3 16
2-2-2009 5 5
2-2-2009 7 12
3-2-2009 3 3
3-2-2009 and so on.

B column contains some data, and 'C' column, contains progressive sum of
cells above it, such that on row1, c1=b1, in row2 c2=c1+b2 and c3=c2+b3 and
so on.
The last row which contains 1-2-2009, contains final total for 1-2-2009.
Row 4 again starts over for new date like c4=b4, then c5=c4+b5.

Is it possible to pick only final totals form column C and paste them in
separate
worksheet in a manner that only final totals will come in that sheet one
below other,
with date, and no intervening cell totals should come.

pl help