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