+ Reply to Thread
Results 1 to 2 of 2

Populating Summary Report

  1. #1
    Registered User
    Join Date
    09-27-2015
    Location
    Dubai, UAE
    MS-Off Ver
    2013
    Posts
    8

    Populating Summary Report

    Hi!

    Need some help.
    I was trying to create a summary report regarding to our repair project.
    All I want on it is to get the total of "D" -delivered, "R" -received, "OP"- on process and "OH"-on hold in whole year.
    And automatically will track in a Percentage Chart in Sheet named "Chart Tracker" to see how many percent every project have been deliver,receive, on process and on hold.
    Also in sheet named Calendar it will automatically will counts the total of "D","R","OP" and "OH" every project.

    Thanks and regards,
    April
    Attached Files Attached Files

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Populating Summary Report

    Perhaps a summary like this will suit. It is a Pivot Table with a Pie chart.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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: 0
    Last Post: 10-14-2015, 12:53 PM
  2. Populating a Summary Workbook
    By Funkshaz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2014, 12:36 PM
  3. Convert Detailed Time Attendance report from Biometrics to Summary Report
    By firescorpio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2013, 02:48 AM
  4. Populating a summary table
    By gregg141 in forum Excel General
    Replies: 2
    Last Post: 03-11-2011, 05:22 PM
  5. Automatically populating Log into Summary
    By auroraivy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2009, 03:37 AM
  6. Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep
    By lukep10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2008, 01:38 PM
  7. [SOLVED] Populating a summary of variable size.
    By shakey1181 in forum Excel General
    Replies: 0
    Last Post: 06-22-2006, 10:50 AM

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