Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb
 
Posts: n/a
Default Summary total from another worksheet?

I am currently trying to setup another worksheet in my workbook to do grand
totals for me.

Is it possible - I have a worksheet I do all my job costing on (daily time,
materials used, etc.) Now I want to add another worksheet to do like a
summary.

I enter daily things into my costing record but it is detailed for our
reference purposes. Is it possible to set up (I need the formulas) a summary
page of a breakdown just on certain items?

Example: we might do Prep, every other day and then P&F (Place & Finsh)
other days, now I just want a total of just Prep, and P&F. Is there a formula
that would lookup the sheet to find a total of specific items?

Right now our Job records are sometimes 15 pages long because we do record
everyhting in them. I am trying to setup a summary page 1-2 pages for just
totals to make it easier when trying to determine certain costing on certain
items.

Thanks a lot, and hopefully I am not trying to do to much!!

tb
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
intruder9
 
Posts: n/a
Default Summary total from another worksheet?


Could you send me an example of one of the bigger ones so I can see
exactly what you have and how it is laid out. sned to



--
intruder9
------------------------------------------------------------------------
intruder9's Profile:
http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=502150

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
Percent of total in Pivot tables Pallet1210A Excel Worksheet Functions 1 September 8th 05 07:12 PM
Referencing worksheet names Rich Hayes Excel Worksheet Functions 3 August 25th 05 08:47 PM
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
Seeking help for total worksheet protection Joseph Geretz Excel Discussion (Misc queries) 10 December 31st 04 06:48 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM


All times are GMT +1. The time now is 12:46 PM.

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"