Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I carry the calculations over to the various worksheets
I am working with multiple worksheets. I've split up the worksheets by
person (8 in total). I need to carry the calculations from each worksheet into one that will total each person time by months. Colomn A = Project No Column B = Project Name Colomn C - Project Manager Column D - Expected Project Start Period Column E = Expected Project Finish Column F-W contains months (example: April '09, etc) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I carry the calculations over to the various worksheets
Hello, one possibility would be a Pivot Table based on multiple consolidation ranges schavez12;324448 Wrote: I am working with multiple worksheets. I've split up the worksheets by person (8 in total). I need to carry the calculations from each worksheet into one that will total each person time by months. Colomn A = Project No Column B = Project Name Colomn C - Project Manager Column D - Expected Project Start Period Column E = Expected Project Finish Column F-W contains months (example: April '09, etc) -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90674 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using multiple worksheets to do calculations | Excel Discussion (Misc queries) | |||
calculations from data in other worksheets | Excel Worksheet Functions | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
How can I format a worksheet to carry out all calculations to 2 d. | Excel Discussion (Misc queries) |