How do I make this work? If the value in worksheet #1 Cell A1 = "1" (Week of
the year) then put the value of Cell B2 into worksheet 2 Cell C3 else leave
the value in C3 alone (I will put this formula in worksheet #1). My next row
of worksheet #2 will ask IF the value in worksheet #1 Cell A1=2 then put the
value of B2 into worksheet #2 Cell C4. If Cell A1<2 then do nothing (leave
the value in C4 alone). The problem is when I change the number of the week
from week 1 to week 2 (in worksheet #1) the formula still wants to calculate
(in worksheet #2) and it puts a "FALSE" in the cell because it is not week 1
anymore.

Worksheet #2 C3 will have Sundays values D3 will have Mondays values etc.
for week 1 of the year. Worksheet #2 C4 will have Sundays sales values for
week 2 of the year. This progression goes on for 52 weeks.

Now when I change the value in worksheet #1 A1 = "2" I want to maintain the
current value in worksheet 2 C3 and have the new sales data entered fall in
the next row down C4. Worksheet #1 will have seven days (one week) with
sales each day. Cell A1 is the week of the year. I will change worksheet #1
Cell A1 every week and enter that week's sales into . Worksheet #2 will have
52 seven day weeks. Worksheet #1 should fill worksheet #2 as the year
progresses and previous week's sales should not be recalculated ending with
52 seven day weeks of sales data.