John,

Use a database and a pivot table based on the database.

Set up your database with (At least) three columns

Date DataSet Value

Then use the pivot table with Date as the column field, set to group by days, 7.... and drag
DataSet to the Row Field, and Value to the data field, set to sum.

HTH,
Bernie
MS Excel MVP


wrote in message
...
I have a spreadsheet called daily data it has two columns of data, at
the end of the day I want to copy the values in column b and paste
them to the spreadsheet weekly data. Each column in weekly data has
values grouped in week ending columns i.e

daily data

DATE = 28/03/08

DATA1 10
DATA2 20
DATA3 20

WEEKLY DATA

WK ENDING 28/03/07 WK ENDING 05/04/2008
DATA1 30
60
DATA2 45
60
DATA3 35
60

I need some code that can work out which week ending column to add the
daily totals too, any help greatly recieved

John