The macro should copy the formulas into the empty rows. Then all you've got to do each week is click on button labeled something like "new week". That seems quite workable.
I am trying to create an excel graph which will have the base data updated week by week through the year.
What I don't want is a graph where lines drop to zero part way through the year
I have found that if the cell being graphed is empty, this doesn't happen, but if the cell contains a formula that equals zero, it does.
I tried changing the formula along the lines of IF(value=0,"",value) but that didn't work.
Because the base data comes from many sources, I want to set up all the links for the base data at the start of the year, and not have to copy formulas week by week throughout the year.
I also don't want to have to go into every series in every graph every week, and alter the range to include 1 more column.
Is there a way to get around this problem?