View Single Post
  #4   Report Post  
RJB
 
Posts: n/a
Default

Thanks, guys. Both suggestions were helpful. I have one more quandary....

I have a few weeks out of each year where I have NO sales...

For example, in Week 31 02, 03, and 04, I have nothing... So my table skips
from Week 30 to Week 32. I'd rather it put in a Week 31. Short of artifically
plugging the source spreadsheet, any thoughts?

HAVE:

WEEK 2002 2003 20004
30 52 68 71
32 39 66 42

WANT:

WEEK 2002 2003 20004
30 52 68 71
31 0 0 0
32 39 66 42