I have a period (4 week) sales goal. As I complete week 1, I need to know
how much remains of my sales goal. I created a spreadsheet which tracks
sales for many accounts for one week (or sheet) at a time. On sheet 2 I need
to subtract the total sales from sheet 1 and show remaining sales goal as of
week (sheet) 2. Basically, on week (sheet) 4 I need to know what remains for
that week. How do I transfer data from sheet 1 to sheet 2; then cumulatively
to sheet 3, and finally, cumulatively to sheet 4. Any help will be
sincerely appreciated! HELP!!