I would like to take information from 1 sheet and insert it in a summary on a
seperate sheet. My information is recorded with date entries (daily) in
column a and amounts in column b. I need to record week ending total and
month ending totals. Column a and b could vary from 1 to 1000 entries. Any
ideas???

eg
column a column b
1/1/2007 20
2/1/2007 45
7/1/2007 9

Thanks