+ Reply to Thread
Results 1 to 3 of 3

time & attendance

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2003
    Posts
    14

    time & attendance

    Hi...
    I need to extract from the sheet 1 data table - the worked time marked in green cells for one month to the sheet 2 table.
    I need to match the name and the date and the value from green cell ofcourse!

    Could anyone help me and at what cost?
    Attached Files Attached Files

  2. #2
    Forum Contributor wallyeye's Avatar
    Join Date
    05-06-2011
    Location
    Arizona
    MS-Off Ver
    Office 2010, 2007
    Posts
    308

    Re: time & attendance

    If you can drop the spelled out day from Sheet1!E:E, you won't actually need any vba for this, a sumproduct will work:

    =SUMPRODUCT(N(Sheet1!$D$2:$D$2000=Sheet2!$C10),N(DAY(Sheet1!$E$2:$E$2000)=Sheet2!F$9),Sheet1!$S$2:$S$2000)

    I've attached the tweaked spreadsheet:

    pontaj-adsoft.xls

  3. #3
    Registered User
    Join Date
    08-08-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: time & attendance

    Thank you! Great Job! You saved me 100 years of work

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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