yEAR TO DATE WORKSHEET
 

I created a worksheet for each month for daily sales. Each worksheet has 3
colums that are totaled at the bottom. I would like to creat a new worksheet
that automatically lists the monthly totals from each worksheet. what is the
best way to do this?

create your new totals sheet.In the cell that you want to display the first
column of your first sheet just type =and then click on the cell with the
totat you want to show......repeat

--
paul
remove nospam for email addy!



"gowvugo" wrote:

I created a worksheet for each month for daily sales. Each worksheet has 3
colums that are totaled at the bottom. I would like to creat a new worksheet
that automatically lists the monthly totals from each worksheet. what is the
best way to do this?