Results 1 to 1 of 1

Thread: Test Attachments

  1. #1
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10

    Test Attachments and stuff :)

    OffenFragen ExcelFox Attachmant Test.docx








    Hi Admin
    I was a bit confused at first.
    I see what you have done now.
    You have taken his AFTER and applied a SUMIF on the two columns I and J....

    So first , You added then the extra column K with H for Holiday and N for normal day,
    Row\Col
    E
    F
    G
    H
    I
    J
    K
    1
    21.Dec.16
    7:00
    18:00
    11:00
    9:00
    2:00
    N
    2
    22.Dec.16
    7:00
    18:00
    11:00
    9:00
    2:00
    N
    3
    23.Dec.16
    7:00
    15:00
    8:00
    8:00
    H
    4
    24.Dec.16
    7:00
    18:00
    11:00
    9:00
    2:00
    N
    5
    25.Dec.16
    7:00
    18:00
    11:00
    9:00
    2:00
    N
    Worksheet: 121

    Then you have these formulas:
    Row\Col
    G
    H
    I
    J
    35
    =SUMIF(K1:K31,"N",J1:J31)
    =SUMIF(K1:K31,"H",J1:J31)



    If Nelson wanted to do that he would still need to use part of my code to get the AFTER worksheet in it final form, as his start point , the BEFORE File is a bit different and needs a bit of manipulation based on his various criteria.
    Row\Col
    E
    F
    G
    H
    I
    J
    1
    21.Dec.16
    7:00
    18:00
    11:00
    9:00
    2:00
    2
    22.Dec.16
    7:00
    18:00
    11:00
    9:00
    2:00
    3
    23.Dec.16
    7:00
    15:00
    8:00
    9:00
    0:00
    4
    24.Dec.16
    7:00
    18:00
    11:00
    9:00
    2:00
    5
    25.Dec.16
    7:00
    18:00
    11:00
    9:00
    2:00
    Worksheet: 121

    _...........
    By the way, I originally assumed that Holiday was a "Holy Friday thing", but I am not sure if that is correct. What I will do in the next post to cover my back and to let your solution to work is do another code, which checks based on the background colour being yellow for a holiday, then does the manipulation of the Worksheet, but also includes then your H or N, and while I am at it pastes in your formulas:

    I expect then Nelson will have more than enough to keep him busy or confuse him

    Alan
    Last edited by DocAElstein; 02-05-2017 at 04:41 PM.

Similar Threads

  1. This is a test Test Let it be
    By Admin in forum Test Area
    Replies: 6
    Last Post: 05-30-2014, 09:44 AM
  2. Replies: 9
    Last Post: 10-17-2013, 05:09 PM
  3. Replies: 2
    Last Post: 01-07-2013, 04:34 PM
  4. Replies: 7
    Last Post: 08-08-2012, 10:24 AM
  5. Replies: 7
    Last Post: 05-09-2012, 11:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •