Results 1 to 18 of 18

Generating a data summary sheet based on multiple criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    613

    Generating a data summary sheet based on multiple criteria

    Dear experts,

    Please refer to the attached data sheet.

    These are some data available in a garment manufacturing unit.

    In "Data Entry" sheet I have to enter values(Input, LIne out, QC out and Packing in) as shown by some example values. Two major criteria upon which the data filtering/sorting should be done are
    " PO(Purchase Order)" and "Colour".

    A PO can have more than one colour. And, the quantities are entered in to the "Data Entry" sheet PO wise, colour wise and size wise. These data can be "input", "Line Out", "QC Out" or "Packing in".

    My requirement is to display these values in a sheet as " Summary". This summary should be generated automatically based on the values entered in to the data entry sheet. Detail labels such as "Input", Line Out", QC out" and "Packing in" should be shown if the size wise data are available or not(if values are not available, "0" value should be shown)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generating Salary Based on Mandays and Multiple Criteria
    By akbar in forum Excel General
    Replies: 16
    Last Post: 12-18-2013, 09:14 AM
  2. MACRO to Pull Data from multiple worksheets onto a summary sheet based on an ID
    By eswonson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2013, 03:31 PM
  3. [SOLVED] Generating summary sheet from excel form
    By krosser in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-03-2013, 02:20 AM
  4. Replies: 0
    Last Post: 03-27-2012, 04:54 PM
  5. Summary Based on Multiple Criteria
    By Phillycheese5 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2006, 11:06 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