Results 1 to 5 of 5

Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data

    Hi

    I am new to this forum and I found it as a great help for beginners as well as for them who need some instant help.
    I am struggling to resolve a problem since one week and was doing lot of search, then I found this forum.

    I have a workbook with multiple sheets (4 to 5 sheets) each contains a weekly data for different users, the work they did, status of the work and hours spend for each work. In the monthly sheet I should get data per user, for each project Id, for each phase, how much actual hours he put. Different users might work on same project, so this should be captured separately. If user A works on project P00010, testing phase on week one and week two, I need the total of hours he spend for the entire month.

    This is very urgent, could anyone please help me. A sample sheet is attached.

    Thanks for your help in advance

    Santosh
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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