Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
search for latest date | Excel Worksheet Functions | |||
how do i set up an expiry date in an Excel worksheet | Excel Worksheet Functions | |||
Remove the year from a date | Excel Worksheet Functions | |||
how to include real time & date on a worksheet | Excel Discussion (Misc queries) | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) |