Hi,

I have to update graphs every second day or so, just now I am doing this
manually by sourcing data then changing the dates etc. Each graph is from a
different tab spreadsheet in the workbook, but the majority of data has the
same row and colums in each tab which it is extracted from ( i.e my firdt
series values). This happens in all but one sheet where it is just the rows
that differ and the colums stay the same (i.e my second series values).
I was wondering if anyone new a simplier and quicker way of doin this as it
is tedious and time consuming.

Thank you,

Ross