Results 1 to 3 of 3

Summary Time Sheet for all Employees

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2004
    Location
    India
    MS-Off Ver
    2013
    Posts
    205

    Summary Time Sheet for all Employees

    I am using Excel 2010 and have the following problem.
    I have attached a sheet showing the Original Data and the Output Sheet showing the desired result required through a macro please.
    I have colored the Cells on both sheets for sake of easy understanding.
    I wish to have data for all Employees one below other as shown in the Output Sheet. Currently it shows data for Emp1 only which I have done through copy paste and then deleted Rows where value was 0 (zero) in Col H (Hours) on Output Sheet.
    Please note the following:
    a) The Employee Names will start from F4 onwards … at present till AX4.
    b) The Employee Names will increase or decrease
    c) Data will start from A11 downwards.
    d) Only Values greater than 0 (zero) should be transferred to the Output Sheet under each Emp Name.
    e) Column I on Output Sheet (EOM) will show the last date of Month taking the Value of Cell A2 on Original Sheet.
    f) Col D, E & F on Output Sheet will show NA for Category Names 2 onwards.
    g) All Category names are merged from A to E Columns (at present Category 1 to Category 5)
    Any help would be greatly appreciated.

    TIA
    Rashid
    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