Posts by Zsolty87

    [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 907"]

    [tr]


    [TD="align: right"]25-03-2019 07:24:30[/TD]

    [td]

    CIP_CIP_BIF00001_

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 08:55:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 09:57:30[/TD]

    [td]

    NBNG50999

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 12:31:30[/TD]

    [td]

    CIP_NBNG50999

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 13:28:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 13:53:30[/TD]

    [td]

    KON10050

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 21:53:30[/TD]

    [td]

    KON10050

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 22:13:30[/TD]

    [td]

    CIP_KON10050_

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 23:11:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 07:11:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 07:53:30[/TD]

    [td]

    QEN00047

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 09:38:30[/TD]

    [td]

    CIP_QEN00047_

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 11:47:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 11:50:30[/TD]

    [td]

    REN07005

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 15:52:30[/TD]

    [td]

    CIP_REN07005

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 16:51:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 17:14:30[/TD]

    [td]

    CIP_CIP_REN07005

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 18:17:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 19:04:30[/TD]

    [td]

    LQN00118

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 21:23:30[/TD]

    [td]

    CIP_LQN00118_

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 22:33:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]27-03-2019 06:33:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [/TABLE]


    This is how I managed to work my way through it with IF, AND and EXACT commands and then I have a macro where I select the rows with X and then copy them to a new sheet where I can construct a graph or chart with a treated data.


    Hope this will give you and idea what I would like a VBA code for.


    Thank you

    [ATTACH=JSON]{"data-align":"none","data-attachmentid":"1216670","data-size":"custom","height":"540","width":"534"}[/ATTACH]


    Hi everyone.


    What I would like here is to compare the texts in column B, if the below cell is the same then ad its value to the first one and delete the row.


    But for example B10 and B11 are not the same as B33:B35 so I would like to compare only the ones which come one after the other.


    See Image above with the first table as raw data and the second as treated data.


    Please help.


    Thank you

    Hi


    I am using Application.Wait Now + TimeSerial() function to give my computer some time after clicking on a tab and add-in to retrieve some data.
    When I run it I can see the mouse goes to the positions required but it doesn't click it until the end of the macro and then clicks them all at once.


    Any idea why or how can I fix this problem. Maybe I can use some other functions instead?


    Thank you