I create a new spreadsheet every week that tracks employee tips. Each
employee has their own sheet in the workbook, and each week has its own
workbook. The employee sheets have their hours worked each day of the week,
their tips calcualted for the day, and their tip total for the week.

I want to create a formula that keeps a running total of employee tips
throughout the year (YTD Tips). I create the current weeks sheet by opening
the previous week and replacing the information. Let's say the Weekly Tips
cell is A10. I want A10 added to the YTD cell everyweek, and to update
automatically every week. Is that possible? Hope I explained it ok. Thanks
for any recommendations.

You are asking for trouble by replacing the information every week. What if you
type in the wrong amount? What if you want to make a correction? How does anyone
check your work?

The standard method of handling this problem would be to create a list of tips
received throughout the year. Your rows would have the date, amount, and
anything else you wanted to track. Your YTD Tips is simply the sum of all rows.

The most popular setup would be to have a header is row 1 (allowing a title for
each column), the sum in row 2 (as in =sum(B:B)), and your data in subsequent
rows.

If you insist on replacing the data every week, you will need a macro to capture
the amount, then add it to your YTD amount.

--
Regards,
Fred


"Good Tipper" <Good wrote in message
...
I create a new spreadsheet every week that tracks employee tips. Each
employee has their own sheet in the workbook, and each week has its own
workbook. The employee sheets have their hours worked each day of the week,
their tips calcualted for the day, and their tip total for the week.

I want to create a formula that keeps a running total of employee tips
throughout the year (YTD Tips). I create the current weeks sheet by opening
the previous week and replacing the information. Let's say the Weekly Tips
cell is A10. I want A10 added to the YTD cell everyweek, and to update
automatically every week. Is that possible? Hope I explained it ok. Thanks
for any recommendations.