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 Pamp;F (Place amp; Finsh)
other days, now I just want a total of just Prep, and Pamp;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
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: www.excelforum.com/member.php...oamp;userid=30107
View this thread: www.excelforum.com/showthread...hreadid=502150
- Jun 22 Fri 2007 20:37
Summary total from another worksheet?
close
全站熱搜
留言列表
發表留言