LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working out total Numbers of Days Pendelfin Excel Discussion (Misc queries) 1 February 2nd 09 11:59 AM
How do I copy sub total data only onto a new worksheet? khuff Excel Discussion (Misc queries) 2 November 13th 08 11:20 PM
Formating Total Number of Days Big Tony Excel Worksheet Functions 6 June 11th 08 11:48 AM
Total number of days between 2 dates guillottes New Users to Excel 1 March 17th 08 12:06 PM
Total last 30 days Eric Excel Worksheet Functions 6 April 6th 07 03:02 AM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"