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) |
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 |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com