I would like to track a cloumn where I want to input the words "Weekly Subtotals" in that column after the last date for the week automatically.

Example:

Date Customer Rate
01/01/06
01/01/06
01/02/06
01/03/06
"Weekly Subtotals" Automatically input this row at end of weekly inputs
01/08/06
01/09/06
01/10/06
01/11/06
01/11/06
01/12/06
"Weekly Subtotals" Same with this - at the end of every week this will automatically be put into column A(whatever)

Please help with some sort of ideas. I am going crazy trying to figuire this one out! THANKS IN ADVANCE!