Hi

I have a spreadsheet with 15 charts. Every month new rows of data are added
to the worksheets. I have to update the charts to contain all the previous
data as well as any new data that is added to the worksheet.

e.g. In January, I have Sheet1 with data from A1:C15. I have the chart that
contains this data. Then in February, Sheet1 is updated and now contains data
from A1:C30. I would like to use a macro to add the new data to the chart.
Can someone help me with the code please? Note, that column A always has a
week commencing date in it. So in February, cells A31, A32, A33, etc contain
the date 00-Jan-00 and cells A1:A30 contain proper dates.