Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
gowvugo
 
Posts: n/a
Default 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?

  #2   Report Post  
paul
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
how do i set up an expiry date in an Excel worksheet AR Voice Excel Worksheet Functions 2 June 6th 05 10:22 PM
Remove the year from a date newbie Excel Worksheet Functions 1 April 16th 05 12:54 AM
how to include real time & date on a worksheet nde Excel Discussion (Misc queries) 1 March 23rd 05 06:43 PM
Despite formatting a column in Excel 2002 worksheet as Short Date. Pete Whalley Excel Discussion (Misc queries) 2 February 7th 05 06:17 PM


All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"