keeping YTD numbers

[Fawn Lagimodiere]

Hi I have a spreadsheet with a weekly column which the numbers will change.
the next two columns will be a YTD column,

eg

Weekly totals YTD totals

35 35

The weekly totals will be added to the YTD. However because the YTD will
always be current week added to previous week the numbers will not recap
properly.

Is there another way to set up the spreadsheet without having 52 columns for
each week to add up to the YTD.

Any help would be appreciated

thanks

 

[Bernard Liengme]

It is not clear what is meant by "However because the YTD will always be
current week added to previous week the numbers will not RECAP properly"

It would be easier to give a solution if we knew the layout (what cell has
what data)
If B2 has week two's weekly value and C1 has previous YTD:
=IF(B2>0,C1+B2,"")
Copy down the column
C cells next to B values will display YTD but other will display nothing
best wishes

 

[Fawn Lagimodiere]

example of the layout is

B2 will have the week totals and C2 will have the YTD.

The way it is set up now is the B2 will always change because we did not
want to have 52 columns going across.

Hope this helps

Fawn

 

[ebloch]

Easy with a macro.

- First make a new column anyplace but it is logical to make it a new "B".
Title it "OldYTD".
If you do not want to see this column the Hide it.

Macro steps:
1. Copy DATA only from YTD to OldYTD, NOT formulas
2. Delete data in current month column
3. Could add steps to rename current month column to a specific month
4. recalc sheet

YTD should have formula = "OldYTD + "current Month"

Eric