+ Reply to Thread
Results 1 to 2 of 2

Sum multi-columns (weeks) in worksheet to single month column in different worksheet

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    Madison, WI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Sum multi-columns (weeks) in worksheet to single month column in different worksheet

    1. I have a worksheet (A) that takes input from another worksheet, start date, scope, number resources, and calculates how many weeks it needs to apply for that project. It also places the number of resources for different phases of the project such as if 5 is the total number of resources then cuts that number in half and applies it to a different task than the main task. Such as develop software = 5 resources but test software = 2.5 resources. So weeks 1 – 4 is 5 resources and weeks 6-8 is 2.5 resources as an example. There are several project running so in any column the resource numbers fluctuate up and down depending on the phase(week) each project is running.

    2. I have a worksheet (B) that has a column for each month and year (Jan-14,Feb-14…Dec-14) that I want to summarize from sheet (A).

    3. I want to update the columns from sheet (A) that is dynamic with the resources (Associated with tasks, but don’t want the tasks copied just resource numbers) and could start in any month.

    4. Sheet A each month has multiple columns as they are based on week. The month consists of 3 to 4 weeks and must sum up each weeks resource in the month.

    Please Login or Register  to view this content.
    Your help would be greatly appreciated. Thank You.
    Last edited by JBeaucaire; 11-13-2014 at 05:32 PM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,667

    Re: Sum multi-columns (weeks) in worksheet to single month column in different worksheet

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 06-13-2016, 11:23 AM
  2. [SOLVED] copy data from cells in a column on one worksheet to a single cell in another worksheet
    By jpsnickers in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2013, 07:02 PM
  3. Need help to copy multi page web data into a single worksheet
    By arock08 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2013, 03:07 AM
  4. Replies: 2
    Last Post: 08-16-2012, 01:41 PM
  5. Generating multi[ple worksheets from a single master worksheet
    By zenadiani in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2010, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1