carrach, if I understand you correctly you want to bring forward Jan total
and add it to Feb total and so on?
I assume your Janauary worksheet tab is 'Jan' and February is 'Feb'
So lets assume your Months' total appears in the same cell D50 on each
worksheet
Then on Feb worksheet, in cell D51 enter formula
=Jan!D50+D50
In Mar worksheet cell D51 enter formula
=Feb!D51+D50 and so on, for each month's worksheet
Change cell reference to suit your senario
Hope this helps

"carrach" wrote:

Hi,
I have a workbook containing several worksheets i.e one worksheet for each
month. I want to use a year to date colum within each worksheet which means
using a formulae that increments across each worksheet.(i.e. in 'feb' sheet
add 'jan year to date' & 'feb actual' figures together and then in March
sheet add feb 'year to date' to March actual figures etc etc) Is this
possible? I have been unable to find any help in any books as most options
seem to be about copying one item to many worksheets which is not the same.