Once again, thanks a million for sticking with me on this ....I'm trying to help a friend set up a simple way for her to track the weekly income of her salon. For accounting purposes, she need keep only the week total, but for her personal interest, she wants to see each days receipts by cash, credit card and check. At the end of the week, the total of all those is to transfer over to a second spreadsheet to be kept as a single number. She does not want/ need 365 days of individual data with three subsets.

I set up a very simple 7 column x 3 row grid; at the end of each row, the week's total for each of the income options, and below that column is the cell with the full week's combined total. It is that total that is linked to the second sheet. The problem is that when the 7x3 grid is cleared of content at the end of the week to start anew, it also creates a zero in the cell with the total sum and therefore since still linked to the second sheet, removes the preeceding sum and creates a zero there as well.

I guess the better question is: is there a way to link not to one cell, but to a full column of (52) cells and have them populate in order without erasing the preceeeding entry when the daily entry grid is cleared at the end of the week?

Thanks
Steve