+ Reply to Thread
Results 1 to 2 of 2

Summarized data based on timetable sequence

  1. 07-28-2019, 03:17 PM #1
    aligahk06
    aligahk06 is offline
    Registered User
    Join Date
    07-03-2010
    Location
    INDIA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Summarized data based on timetable sequence

    Dear All,

    I have a time card and i want to summarize under following condition.
    1. based on timetable column E , all emp # i.e column A associated with same timetable should appear in one sheet or in sequence order. then next timetable with corresponding all employees and so on.
    eg. emp# 17 consist of seven records starting week day from 16/7/2019 to 24/7/2019 and timetable name 08:00 - 16:00 .
    So one timetable associated with all employee appear in one place and then next timetable with all employee at order or in separate sheets.


    Please assist..
    Rgds,
    aligahk06
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-31-2019, 11:23 AM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Summarized data based on timetable sequence

    I may be misunderstanding, however it seems that this could be accomplished using the Show Report Filter Pages option of a pivot table.
    1. Produce a pivot table with Date in the Filter field and all others in the Row field.
    2. From the Pivot Table Analyze tab select Options > Show Report Filter Pages > Date > OK
    Note that the directions in step #2 are based on a more recent version of Excel, however it appears that the 2007 version does have the feature.
    If this isn't what you want, please upload a small sample of a few sheets showing how you would like to see the output.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] formatting/formula based on timetable
    By netimports in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-28-2017, 10:03 PM
  2. Data from two sheets summarized in a third sheet
    By excelninho in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2014, 01:50 AM
  3. [SOLVED] Data Challenge: turning massive amounts of sales order data into summarized customer data
    By amiller in forum Excel General
    Replies: 34
    Last Post: 01-21-2014, 03:07 PM
  4. Summarized Data in one Sheet
    By khurramfarooqpk in forum Excel General
    Replies: 11
    Last Post: 07-02-2013, 03:34 AM
  5. Sum values based on operational timetable
    By freud1 in forum Excel General
    Replies: 4
    Last Post: 10-06-2011, 08:19 AM
  6. summarized data as cut & paste
    By Lisa2 in forum Excel General
    Replies: 2
    Last Post: 08-08-2007, 12:25 PM
  7. How do I change how PivotChart data is summarized, from sum to av.
    By csavage in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2005, 01: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1